使用SMO只复制数据
我试图仅使用SMO复制数据，并且在处理数据时出错
Microsoft.SqlServer.Management.Common.TransferException:传输数据时发生错误。有关详细信息，请参阅内部异常。( Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServer(DbDataReader阅读器))在D:\Source\atlas-cli\src\Commands\CopyDataCommand.cs:line 114中的D：\Source\atlas-cli\src\Commands\CopyDataCommand.cs:line 114中的D：\Source\atlas-cli\src\Commands\CopyDataCommand.cs:line 114中的CancellationToken sourceConnection、SqlConnection destinationConnection、TransferWriter writer、SqlTransaction事务)在Microsoft.SqlServer.Management.Smo.Transfer.TransferData() -内部异常堆栈跟踪的末端-在AtlasCLI.Commands.CopyDataCommand.CopyAllTablesData(CatalogSourceEndpoint源代码的Microsoft.SqlServer.Management.Smo.Transfer.TransferData() at AtlasCLI.Commands.CopyDataCommand.CopyAllTablesData(CatalogSourceEndpoint源文件中。
你可以在这里找到我的背景：
var transfer = new Transfer(sourceServer.Databases[sourceConnection.Database])
{
Options =
{
WithDependencies = true,
ContinueScriptingOnError = true,
AllowSystemObjects = true,
Indexes = true,
IncludeIfNotExists = true,
DriAll = true,
SchemaQualify = true,
ScriptSchema = false,
ScriptData = true
},
DestinationDatabase = destinationConnection.Database,
DestinationServer = destinationServer.Name,
DestinationLoginSecure = true,
CopySchema = false,
CopyData = true
};
transfer.DataTransferEvent += DataTransferEvent_Handler;
transfer.DiscoveryProgress += DiscoveryProgress_Handler;
transfer.ScriptingProgress += ScriptingProgressReport_Handler;
transfer.ScriptingError += ScriptingErrorReport_Handler;
transfer.TransferData();回答 1
Stack Overflow用户
发布于 2021-05-12 18:44:08
我需要更改目标数据库排序规则。
ALTER DATABASE [mydatabase]
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
Go
ALTER DATABASE [mydatabase] COLLATE SQL_Latin1_General_CP1_CI_AI
Go
ALTER DATABASE [mydatabase]
SET MULTI_USERhttps://stackoverflow.com/questions/67491338
复制相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号