May 29, 2005 at 1:06 am
Hi,
I am trying to import data from an SQL2000 database to a 7.0 database. Most of the tables' rows get transferred but for some tables some rows are not getting imported.
I have tried multiple times but the same less number gets imported. Tried importing with deleting target rows also but no use
Any ideas on this ??
Regards
Phani
May 30, 2005 at 10:04 am
A few questions that may help:
Is DTS giving any error messages about rows not being transferred?
Are the table structures exactly the same between the 2 databases? (check unique indexes that require unique values for example)
Are there any triggers in the SQL 7.0 database that may be deleting records as they are imported?
Hope this helps,
Andrew
May 31, 2005 at 7:59 am
If it is not including same rows everytime, it might be bad data in source.
June 1, 2005 at 1:02 am
h!!,
In this scenario you can select the tables in which data is not transfered & clear the checkbox for ENFORCE RELATIONSHIP FOR INSERTS AND UPDATES
Regards,
Vinod (DBA)
HTC Global Services Chennai
Mob:09840856202
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply