问题描述
你好团队,
我试图将一些表从一个Azure SQL DB批量复制到另一个。
I tried to bulk copy some tables from one Azure SQL DB to another.
目标数据库是空的,没有。
The destination DB is empty and nothing there.
我按照以下链接执行了步骤:
I followed the steps with this link:
https://docs.microsoft.com/en-us/azure/data-factory/tutorial -bulk-copy-portal
https://docs.microsoft.com/en-us/azure/data-factory/tutorial-bulk-copy-portal
提供的示例略有不同,因为目标是SQL DW而不是SQL DB,其余的是相同。
The example provided is slightly different as the destination is SQL DW rather than SQL DB, the rest are the same.
在此过程中失败并返回以下错误代码:
During the process it failed and the following error code returned:
{" errorCode":" 2200"," message":" ErrorCode = UserErrorInvalidColumnName,'Type = Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,消息=列
& id;&在表& dbo.test2&,中不存在。 ServerName:& mstbisql01.database.windows.net&, DatabaseName:& TESTDB&。,Source = Microsoft.DataTransfer.ClientLibrary,'Type = System.InvalidOperationException,Message = Can not can
access destination table& [dbo]。[test2]& ;',Source = System.Data,''Type = System.Data.SqlClient.SqlException,Message = Invalid object name& dbo.test2&。,Source = .Net SqlClient Data Provider,SqlErrorNumber = 208,Class = 16,ErrorCode = -2146232060,State = 1,Errors = [{Class = 16,Number = 208,State = 1,Message = Invalid
object name& dbo.test2& 。,},],'"," failureType":" UserError"," target":" CopyData" }
但是,如果我将目标更改为Azure Blob是可行的,可以创建单独的文件并复制数据,这意味着步骤中的动态设置是正确的。
我的猜测是目标数据库没有元数据(根据源表)因此,该过程失败。
可以在不指定元数据的情况下将数据复制到数据库吗?
Can the data be copied to database without specifying the metadata?
如果是事实并非如此,我怎么能实现这个目标?
If that is not the case, how can I achieve this?
非常感谢。
亲切的问候,
Tom Sun
推荐答案
是否有高手其他SQL服务器中的数据库?
Is there master database there in other SQL server?
这篇关于如何将表从一个Azure SQL DB批量复制到另一个Azure SQL DB的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!