Posted by Bob on 01/28/07 01:50

Trying to transfer databases from MSDE to SQL. When I use SQL
Enterprise Manager - DTS - import or export, it works for the first
database, but then fails for the others. I select the to and from
databases using DTS - Import - 'MS OLE DB Provider for SQL Server',
then select 'Copy objects and data between SQL Servers'. It fails
with the generic error message: 'Copy objects failed', nothing
further. I tried to just copy data, and it doesn't work totally. On
two databases, it said that it copied everything, but when I go in
under Enterprise manager, some of the tables are incomplete, i.e. no
data, table shows up in the list, but if you try to look at it, it
says that it is missing or empty. Also, one table was not even
copied. In the other two cases, I get errors, does not copy all
tables. I get errors, like insert fails, but the column it references
for the table does not even exist in that table. Any suggestions
would be appreciated.

[Back to original message]