DTS import does not get all rows

  • 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

  • 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

  • If it is not including same rows everytime, it might be bad data in source.

  • 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