Bug in DTSgreenspun.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
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,
-- Anonymous, January 31, 2001