Bug in DTS

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

When I Transferred the database using DTS from 7.0 to 7.0 . I found certain datas are missing . Some tables does not contain all the data of the source . Also during data transfer there is no warning and message successfully transferred.

Is it a bug in 7.0 .The sqlserver 7 has all necessary SP's upgraded Anyone had this kinda of problem

Please help me

Thanks T.Shanmugasundaram '

-- Anonymous, January 29, 2001

Answers

Shanmugasundaram,

Did you check the "Copy objects and data between SQL Server databases" option rather than the "Copy table(s) and view(s) from the source database" option? Did you have enough room? Was it a new database with nobody accessing it?

Hope this helps,

Eric

-- Anonymous, January 31, 2001


Moderation questions? read the FAQ