Hello
I have a similar problem after updating from version 6.9.0.114 to version 6.11.1.363 gets the error: i call MigrateDataFromMDB.exe:
C:\Program Files\Red Gate\SmartAssembly 6\MigrateFromMDB>MigrateDataFromMDB.exe "C:\ProgramData\Red Gate\SmartAssembly\database.mdb" ".\SQLEXPRESS" Log and exception:
97300 rows copied so far to database Names
97400 rows copied so far to database Names
97500 rows copied so far to database Names
97600 rows copied so far to database Names
97700 rows copied so far to database Names
97800 rows copied so far to database Names
97900 rows copied so far to database Names
98000 rows copied so far to database Names
98100 rows copied so far to database Names
98200 rows copied so far to database Names
98300 rows copied so far to database Names
98400 rows copied so far to database Names
98500 rows copied so far to database Names
98600 rows copied so far to database Names
98700 rows copied so far to database Names
98800 rows copied so far to database Names
Unbehandelte Ausnahme: System.Data.SqlClient.SqlException: Verletzung der PRIMAR
Y KEY-Einschränkung 'NamePrimaryKey'. Ein doppelter Schlüssel kann in das dbo.Na
mes-Objekt nicht eingefügt werden. Der doppelte Schlüsselwert ist (1).
Die Anweisung wurde beendet.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boole
an breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exceptio
n, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateOb
ject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlComman
d cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
TdsParserStateObject stateObj, Boolean& dataReady)
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand c
mdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, Td
sParserStateObject stateObj)
bei System.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkC
opyHandler)
bei System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(Bulk
CopySimpleResultSet internalResults, String updateBulkCommandText, CancellationT
oken cts, TaskCompletionSource`1 source)
bei System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpl
eResultSet internalResults, String updateBulkCommandText, CancellationToken cts,
TaskCompletionSource`1 source)
bei System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSe
t internalResults, String updateBulkCommandText, CancellationToken cts, TaskComp
letionSource`1 source)
bei System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync
(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionS
ource`1 source)
bei System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(Cancella
tionToken cts, TaskCompletionSource`1 source)
bei System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(Cancellation
Token ctoken)
bei System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 colum
nCount, CancellationToken ctoken)
bei System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowS
tate rowState)
bei MigrateDataFromMDB.Program.CopyData(OleDbConnection accessConnection, Sql
Connection sqlConnection, SqlTransaction trans, String commandString, String des
tination)
bei MigrateDataFromMDB.Program.Main(String[] args)
I don't have any data in the database...
BR / comments
- Community
- SmartAssembly
- Error Migrating SmartAssembly Database to SQL
Hello
I have a similar problem after updating from version 6.9.0.114 to version 6.11.1.363 gets the error:i call MigrateDataFromMDB.exe:
C:\Program Files\Red Gate\SmartAssembly 6\MigrateFromMDB>Mig...
0 votes
