带副本的 Azure SQL DB 导入-6ren

带副本的 Azure SQL DB 导入

转载作者：行者123 更新时间：2023-12-03 04:24:00

我正在开发一个 ARM 模板，该模板将要求提供逗号分隔的数据库名称列表，然后使用 copyIndex 函数创建它们。这方面效果很好，但我的解决方案的下一步却不是。接下来我想做的是为每个数据库导入一个 .bacpac 文件，以便完成后可以使用。

验证错误表明问题出在导入资源dependsOn 中的concat 函数上。我已经用几种不同的方法对其进行了测试，但看不出它错在哪里。

我看到的确切错误消息是......

Unable to process template language expressions for resource '/subscriptions/xxxxxx-xxxxx-xxxxxx-xxxxx/resourceGroups/testGroup/providers/Microsoft.Sql/servers/testsql/databases/CustomersDB/extensions/import' at line '858' and column '10'. 'The provided parameters for language function 'concat' are invalid. Either all or none of the parameters must be an array.

**添加了整个模板

"$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"location": {
  "type": "string",
  "defaultValue": "centralus"
},
"sqlAdminUsername": {
  "type": "string"
},
"sqlAdminPassword": {
  "type": "securestring"
},
"sqlServerName": {
  "type": "string"
},
"sqlDatabaseNames": {
  "type": "array",
  "defaultValue": [
    "CustomersDB",
    "WideWorldImporters-Standard"
  ]
},
"sqlEdition": {
  "type": "string",
  "defaultValue": "Standard"
},
"sqlRequestedServiceObjectiveName": {
  "type": "string",
  "defaultValue": "S2"
},
"sqlMaxSizeBytes": {
  "type": "string",
  "defaultValue": "268435456000"
},
"publicIP": {
  "type": "string"
},
"_artifactsLocationSasToken": {
  "type": "securestring"
},
"_artifactsLocation": {
  "type": "string"
}
},
"variables": {
"storageKeyType": "SharedAccessKey",
"collation": "SQL_Latin1_General_CP1_CI_AS"
},
"resources": [
  {
    "name": "[parameters('sqlServerName')]",
    "type": "Microsoft.Sql/servers",
    "apiVersion": "2014-04-01-preview",
    "location": "[parameters('location')]",
    "properties": {
      "administratorLogin": "[parameters('sqlAdminUsername')]",
      "administratorLoginPassword": "[parameters('sqlAdminPassword')]",
      "version": "12.0"
    },
    "resources": [
      {
        "name": "AllowAllWindowsAzureIps",
        "type": "firewallrules",
        "apiVersion": "2014-04-01-preview",
        "location": "[parameters('location')]",
        "dependsOn": [
          "[concat('Microsoft.Sql/servers/', parameters('sqlServerName'))]"
        ],
        "properties": {
          "endIpAddress": "0.0.0.0",
          "startIpAddress": "0.0.0.0"
        }
      },
      {
        "name": "Allow_Remote_SSMS",
        "type": "firewallrules",
        "apiVersion": "2014-04-01-preview",
        "location": "[parameters('location')]",
        "dependsOn": [
          "[concat('Microsoft.Sql/servers/', parameters('sqlServerName'))]"
        ],
        "properties": {
          "startIpAddress": "[parameters('publicIP')]",
          "endIpAddress": "[parameters('publicIP')]"
        }
      }
    ]
  },
  {
    "name": "[concat(parameters('sqlServerName'), '/', parameters('sqlDatabaseNames')[copyIndex()])]",
    "type": "Microsoft.Sql/servers/databases",
    "location": "[parameters('location')]",
    "apiVersion": "2014-04-01-preview",
    "copy": {
      "count": "[length(parameters('sqlDatabaseNames'))]",
      "name": "sql-copy"
    },
    "dependsOn": [ "[resourceId('Microsoft.Sql/servers/', parameters('sqlServerName'))]" ],
    "properties": {
      "collation": "[variables('collation')]",
      "edition": "[parameters('sqlEdition')]",
      "maxSizeBytes": "[parameters('sqlMaxSizeBytes')]",
      "requestedServiceObjectiveName": "[parameters('sqlRequestedServiceObjectiveName')]"
    }
  },
  {
    "name": "[concat(parameters('sqlServerName'), '/', parameters('sqlDatabaseNames')[copyIndex()],'/','import')]",
    "type": "Microsoft.Sql/servers/databases/extensions",
    "apiVersion": "2014-04-01-preview",
    "dependsOn": [ "sql-copy" ],
    "copy": {
      "name": "sql-import",
      "count": "[length(parameters('sqlDatabaseNames'))]"
    },
    "properties": {
      "storageKeyType": "[variables('storageKeyType')]",
      "storageKey": "[parameters('_artifactsLocationSasToken')]",
      "storageUri": "[concat(parameters('_artifactsLocation'), '/', 'databaseFiles', '/', parameters('sqlDatabaseNames'), '.bacpac')]",
      "administratorLogin": "[parameters('sqlAdminUsername')]",
      "administratorLoginPassword": "[parameters('sqlAdminPassword')]",
      "operationMode": "Import"
    }
  }
],
}

最佳答案

据我所知，我们无法在嵌套资源中使用copyindex函数。

如果您运行arm模板，您将面临以下错误:

Copying nested resources is not supported. Please see https://aka.ms/arm-copy/#looping-on-a-nested-resource for usage details.'.

所以我建议您将嵌套资源移动为arm模板中的根资源。然后你可以使用复制索引。

更多详细信息，您可以引用下面的arm模板:

注意:将参数 orb 替换为您的数据库名称。

{
  "$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "brandosqlAdminLogin": {
      "type": "string",
      "minLength": 1
    },
    "brandosqlAdminLoginPassword": {
      "type": "string"
    },
    "org": {
      "type": "array",
      "defaultValue": [
        "contoso",
        "fabrikam",
        "coho"
      ]
    },
    "copydatabaseCollation": {
      "type": "string",
      "minLength": 1,
      "defaultValue": "SQL_Latin1_General_CP1_CI_AS"
    },
    "copydatabaseEdition": {
      "type": "string",
      "defaultValue": "Basic",
      "allowedValues": [
        "Basic",
        "Standard",
        "Premium"
      ]
    },
    "copydatabaseRequestedServiceObjectiveName": {
      "type": "string",
      "defaultValue": "Basic",
      "allowedValues": [
        "Basic",
        "S0",
        "S1",
        "S2",
        "P1",
        "P2",
        "P3"
      ],
      "metadata": {
        "description": "Describes the performance level for Edition"
      }
    },
    "copy2StorageKeyType": {
      "type": "string",
      "minLength": 1
    },
    "copy2StorageKey": {
      "type": "string"
    },
    "copy2StorageUri": {
      "type": "string",
      "minLength": 1
    },
    "copy2AdministratorLogin": {
      "type": "string",
      "minLength": 1
    },
    "copy2AdministratorLoginPassword": {
      "type": "string"
    },
    "serverDatabaseName": {
      "type": "array",
      "defaultValue": [
        "brandoimprottest/contoso",
        "brandoimprottest/fabrikam",
        "brandoimprottest/coho"
      ]
    },

    "copysqldatabase2Collation": {
      "type": "string",
      "minLength": 1,
      "defaultValue": "SQL_Latin1_General_CP1_CI_AS"
    },
    "copysqldatabase2Edition": {
      "type": "string",
      "defaultValue": "Basic",
      "allowedValues": [
        "Basic",
        "Standard",
        "Premium"
      ]
    },
    "copysqldatabase2RequestedServiceObjectiveName": {
      "type": "string",
      "defaultValue": "Basic",
      "allowedValues": [
        "Basic",
        "S0",
        "S1",
        "S2",
        "P1",
        "P2",
        "P3"
      ],
      "metadata": {
        "description": "Describes the performance level for Edition"
      }
    }

  },
  "variables": {
    "brandosqlName": "brandoimprottest"
    },
  "resources": [
    {
      "name": "[variables('brandosqlName')]",
      "type": "Microsoft.Sql/servers",
      "location": "[resourceGroup().location]",
      "apiVersion": "2014-04-01-preview",
      "dependsOn": [],
      "tags": {
        "displayName": "brandosql"
      },
      "properties": {
        "administratorLogin": "[parameters('brandosqlAdminLogin')]",
        "administratorLoginPassword": "[parameters('brandosqlAdminLoginPassword')]"
      },
      "resources": [
        {
          "name": "AllowAllWindowsAzureIps",
          "type": "firewallrules",
          "location": "[resourceGroup().location]",
          "apiVersion": "2014-04-01-preview",
          "dependsOn": [
            "[resourceId('Microsoft.Sql/servers', variables('brandosqlName'))]"
          ],
          "properties": {
            "startIpAddress": "0.0.0.0",
            "endIpAddress": "0.0.0.0"
          }
        }
      ]
    },
    {
      "name": "[concat(variables('brandosqlName'), '/', parameters('org')[copyIndex()])]",
      "type": "Microsoft.Sql/servers/databases",
      "location": "[resourceGroup().location]",
      "apiVersion": "2014-04-01-preview",
      "copy": {
        "count": 3,
        "name": "sql-copy"
      },
      "dependsOn": [ "[resourceId('Microsoft.Sql/servers', variables('brandosqlName'))]" ],
      "tags": {
        "displayName": "copysqldatabase2"
      },
      "properties": {
        "collation": "[parameters('copysqldatabase2Collation')]",
        "edition": "[parameters('copysqldatabase2Edition')]",
        "maxSizeBytes": "1073741824",
        "requestedServiceObjectiveName": "[parameters('copysqldatabase2RequestedServiceObjectiveName')]"
      }
    },
    {
      "name": "[concat(variables('brandosqlName'), '/', parameters('org')[copyIndex()],'/','aaaa')]",
      "type": "Microsoft.Sql/servers/databases/extensions",
      "apiVersion": "2014-04-01-preview",
      "dependsOn": [ "sql-copy" ],
      "tags": {
        "displayName": "copy3"
      },
      "copy": {
        "name": "sql-copy2",
        "count": 3
      },
      "properties": {
        "storageKeyType": "[parameters('copy2StorageKeyType')]",
        "storageKey": "[parameters('copy2StorageKey')]",
        "storageUri": "[parameters('copy2StorageUri')]",
        "administratorLogin": "[parameters('copy2AdministratorLogin')]",
        "administratorLoginPassword": "[parameters('copy2AdministratorLoginPassword')]",
        "operationMode": "Import"
      }
    }
  ],
  "outputs": {}
}

结果:

<小时/>

我也测试了你的模板，我发现你的导入扩展中的存储网址有问题。我用主存储 key 和 url 更改了它。效果很好。

模板:

{
  "$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "location": {
      "type": "string",
      "defaultValue": "eastasia"
    },
    "sqlAdminUsername": {
      "type": "string"
    },
    "sqlAdminPassword": {
      "type": "string"
    },
    "sqlServerName": {
      "type": "string"
    },
    "sqlDatabaseNames": {
      "type": "array",
      "defaultValue": [
        "CustomersDB",
        "WideWorldImporters-Standard"
      ]
    },
    "sqlEdition": {
      "type": "string",
      "defaultValue": "Standard"
    },
    "sqlRequestedServiceObjectiveName": {
      "type": "string",
      "defaultValue": "S2"
    },
    "sqlMaxSizeBytes": {
      "type": "string",
      "defaultValue": "268435456000"
    },
    "publicIP": {
      "type": "string"
    },
    "copy2StorageKeyType": {
      "type": "string",
      "minLength": 1
    },
    "copy2StorageKey": {
      "type": "string"
    },
    "copy2StorageUri": {
      "type": "string",
      "minLength": 1
    }

  },
  "variables": {
    "storageKeyType": "SharedAccessKey",
    "collation": "SQL_Latin1_General_CP1_CI_AS"
  },
  "resources": [
    {
      "name": "[parameters('sqlServerName')]",
      "type": "Microsoft.Sql/servers",
      "apiVersion": "2014-04-01-preview",
      "location": "[parameters('location')]",
      "properties": {
        "administratorLogin": "[parameters('sqlAdminUsername')]",
        "administratorLoginPassword": "[parameters('sqlAdminPassword')]",
        "version": "12.0"
      },
      "resources": [
        {
          "name": "AllowAllWindowsAzureIps",
          "type": "firewallrules",
          "apiVersion": "2014-04-01-preview",
          "location": "[parameters('location')]",
          "dependsOn": [
            "[concat('Microsoft.Sql/servers/', parameters('sqlServerName'))]"
          ],
          "properties": {
            "endIpAddress": "0.0.0.0",
            "startIpAddress": "0.0.0.0"
          }
        },
        {
          "name": "Allow_Remote_SSMS",
          "type": "firewallrules",
          "apiVersion": "2014-04-01-preview",
          "location": "[parameters('location')]",
          "dependsOn": [
            "[concat('Microsoft.Sql/servers/', parameters('sqlServerName'))]"
          ],
          "properties": {
            "startIpAddress": "[parameters('publicIP')]",
            "endIpAddress": "[parameters('publicIP')]"
          }
        }
      ]
    },
    {
      "name": "[concat(parameters('sqlServerName'), '/', parameters('sqlDatabaseNames')[copyIndex()])]",
      "type": "Microsoft.Sql/servers/databases",
      "location": "[parameters('location')]",
      "apiVersion": "2014-04-01-preview",
      "copy": {
        "count": "[length(parameters('sqlDatabaseNames'))]",
        "name": "sql-copy"
      },
      "dependsOn": [ "[resourceId('Microsoft.Sql/servers/', parameters('sqlServerName'))]" ],
      "properties": {
        "collation": "[variables('collation')]",
        "edition": "[parameters('sqlEdition')]",
        "maxSizeBytes": "[parameters('sqlMaxSizeBytes')]",
        "requestedServiceObjectiveName": "[parameters('sqlRequestedServiceObjectiveName')]"
      }
    },
    {
      "name": "[concat(parameters('sqlServerName'), '/', parameters('sqlDatabaseNames')[copyIndex()],'/','import')]",
      "type": "Microsoft.Sql/servers/databases/extensions",
      "apiVersion": "2014-04-01-preview",
      "dependsOn": [ "sql-copy" ],
      "copy": {
        "name": "sql-import",
        "count": "[length(parameters('sqlDatabaseNames'))]"
      },
      "properties": {
        "storageKeyType": "[parameters('copy2StorageKeyType')]",
        "storageKey": "[parameters('copy2StorageKey')]",
        "storageUri": "[parameters('copy2StorageUri')]",
        "administratorLogin": "[parameters('sqlAdminUsername')]",
        "administratorLoginPassword": "[parameters('sqlAdminPassword')]",
        "operationMode": "Import"
      }
    }
  ]
}

结果:

关于带副本的 Azure SQL DB 导入，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/45697375/

文章推荐： Azure 逻辑应用程序 Sql 连接器

文章推荐： xcode - 有没有在 Xcode 中进行 block 注释的快捷方式？

文章推荐： r - 如何从多个向量中找到共同元素？

文章推荐： c# - 引用 .ccproj 中的运行时内容 (Azure SDK 2.9)

python - 我应该将产品图像存储为 db.ListProperty(db.Blob) 还是 db.ListProperty(db.Key)？
我当前正在存储给定产品的上传图像，如下所示: class Product(db.Model): images= db.ListProperty(db.Blob) # More prop
ruby-on-rails - 更快地编写此 rake 命令的方法 - rake db :drop db:create db:migrate db:seed
每次对架构或新迁移文件进行更改时，我都会运行以下命令: rake db:drop db:create db:migrate db:seed 是否有预先构建的等效方法来执行此操作？我从我读到的内容中想
Android Room 数据库文件为空 - .db、.db-shm、.db-wal
在 android 中使用房间作为数据库。当我试图在 sqlviewer 中查看数据时，在数据库文件中找不到表Myapp.db 文件为空。数据/data/packageName/databases/M
ruby-on-rails - 在每个场景之前在 cucumber 中运行 exec 'rake db:drop db:create db:migrate db:seed'
我搜索并尝试了很多次，但没有找到我的答案。我有一些用小 cucumber (在 Rails 项目中)编写的项目的功能文件。所有步骤都已定义，如果我单独启动它们，功能本身运行得很好。我可以将所有场景与我
ruby-on-rails - db :test:clone, db :test:clone_structure, db :test:load, 和 db :test:prepare? 有什么区别
您必须承认，对于 Rails 和数据库的新手来说，rubyonrails.org 上的官方解释使所有这四个任务听起来完全一样。引用: rake db:test:clone Recreate the
ruby-on-rails - 在Heroku Cedar堆栈上运行rake db:drop db:create db:migrate
当我尝试运行时: heroku run rake db:drop db:create db:migrate 我得到错误: Running rake db:drop attached to termin
ruby-on-rails - rake db :migrate db:reset and db:schema:load之间的区别
rake db:migrate 和 rake db:reset 之间的区别对我来说非常清楚。我不明白的是 rake db:schema:load 与前两者有何不同。只是为了确保我在同一页面上: ra
azure - 从 Azure 函数将对象列表保存到 cosmos DB(文档 DB 或 mongo DB)
我们都知道，我们可以使用 Azure 函数(使用 out 参数或使用 return)在 cosmos DB 中一次保存一个文档，例如: object outputDocument = new { i
php - mysql-db 请求 : how to get the db-name and the db-type as output of the request
我有一个包含 60 多个表的 mysql 数据库。这是在我将 joomla 版本 2.5.3 从本地灯移植到网络服务器时构建的。我运行 mysql-db: 移植后我发现我无法登录 amdin 区域。
c# - 如何使用 EF DB First 将 SQL DB 迁移到 Azure SQL DB
我想轻松地将现有数据库迁移到 Azure 托管。在我的项目中，我使用 Entity Framework DB First。有什么经验教训或例子可以说明如何做到这一点吗？最佳答案您本地使用什么数据库
ios - 核心数据 WAL 模式不会持久化对 .db 的更改，只有 .db-wal 和 .db-shm
所以，我一直在使用 MagicalRecord 开发 iPad 应用程序，最近在转移到自动迁移商店后我遇到了一些问题。我需要将我的 .db 文件从一个设备同步到另一个设备，所以我需要所有数据都在 .d
ruby-on-rails - database.yml 文件配置和 postgres - rake db :drop db:create db:migrate
自从我在 Heroku 上部署并希望与生产相匹配后，我最近切换到 postgres 来开发一个 Rails 应用程序。当我将数据库名称设置为“postgres”时，我的应用程序安装了 Postgres
sql-server - 使用 Microsoft OLE DB 提供程序和 SQL Native OLE DB 提供程序建立 DB 连接
我使用 oledb 提供程序(SQLOLEDB 和 SQL Native OLEDB 提供程序)创建了一个示例应用程序。案例 1:提供者 = SQLOLEDB hr = ::CoInitialize
node.js - db.collection.insert 与 db.collection.insertOne 和 db.collection.insertMany 的性能影响
我正在为 NodeJs 使用 mongodb 驱动程序，其中有 3 个方法: 1) db.collection.insert 2) 数据库.collection.insertOne 3) db.col
clojure - db.part/db 的所有字段是什么意思？
我是 datomic 的新手，我仍在努力弄清楚系统是如何构建的。特别是，我不明白 :db.part/db 扮演什么角色，因为每次安装架构时似乎都需要它。有人可以解释一下这一切意味着什么吗？ (需要 '
berkeley-db - Berkeley DB 中的空间索引
Berkeley DB 是否有空间索引，例如 R-tree？最佳答案有人问the same question on the Oracle forum .还没有甲骨文回答。但答案是否定的，它没有任何
php - $db = new DB() 混淆
请解释一下这是什么意思 $db = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE); 它给了我一个错误 "E
berkeley-db - berkeley-db-je 的最新版本是什么？
berkeley-db-je 的最新版本是什么？来自 oracle , 为 7.5。但来自maven存储库，它是 18.3.12。有没有人知道更多的细节？最佳答案 Berkeley DB Ja
codeigniter - $this->db->replace() 的区别 $this->db->update()
我不明白查询构建器的替换和更新之间的区别。尤其是替换文档... This method executes a REPLACE statement, which is basically the SQL
berkeley-db - Berkeley DB 是开源的吗？我在哪里可以找到它的源代码？
看起来 BerkeleyDB 被 Oracle 收购了，它没有在其网站上发布源代码？最佳答案 Sleepycat 于 2006 年被 Oracle 收购。该产品继续在原始开源许可下可用，并继续得到增

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

带副本的 Azure SQL DB 导入