Issues Migrating from SQL CE to EXPRESS.

[DonSlice]

I sent in an email about this, but I figured I'd drop a line to see if the community has any advice.

I'm having a little bit of trouble migrating from SQL Compact to SQL Express on a different server, using the utility (CompactToServer.exe). Everything seems like it's working correctly, but then it throws an error:

One or more errors prevented correct data transfer;
Cannot insert duplicate key row in object 'dbo.tblAutorunUni' with unique index 'IX_tblAutorunUni'.
The statement has been terminated (table: tblAutorunUni)
Violation of UNIQUE KEY constraint 'IX_tblGroupUni'. Cannot insert duplicte key in object 'dbo.tblGroupUni)
Execution time was 00:07:41

Has anyone else encountered this?

[Hemoco · Accepted solution]

These errors can possibly be ignored. (They indicate that the migration tool tried to insert a value into a table that was already present.) Is your installation operating as normal after the migration? In some case index issue prevent the creation of views or tables.