Post reply

DTS Error: Forigen key constraint

  • November 7, 2008 at 12:29 am

    #94691

    Hi,

    I have to copy 5 tables from Prod Server A to Prod Server B. I have scripted the table structure and created the tables in Prod B. I moved the data from tables from Prod A to Prod B throghh DTS import Export. 4 tables have been copied. The 5th table which has the foriegn key relation with one of the for tables has a problem.

    INSERT statement conflicted with COLUMN FORIEGN KEY CONSTRAINT ' Tblabc..'. The conflict occured in database ' DBabc', 'Tblabc', column'colabdc'

    Can anyone adivse what can be done ??

  • November 7, 2008 at 8:55 am

    #895618

    The table that gets the error (child table) refers to another table (parent table), right? Are you importing data for the parent table before the child table?

    You can't control the order the tables are imported when using the import/export wizard, so you'll either have to import the tables one at a time or drop the foriegn key constraint before importing and recreate it after importing.

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply