Post reply

upload data

  • March 22, 2005 at 6:34 am

    #163987

    Thanks again in advance for the help.

    Now I am trying to upload data from one database to another. THe data schema changed so I am trying to salvage data from one source and upload into the current schema. I'm running into all kinds of problems with constraints. It looks like I would have to manually go in and remove all RI constraints, all identity columns,etc. to get this done. Surely it can't be this difficult. BOL hasn't helped me much.

    TIA

    Sam

  • March 23, 2005 at 1:27 am

    #548391

    Hi

    you can try setting the nocheck constraint on the tables and then load the data.  The following statement would ignore the RI Constraints and  check constraints. 

    For Eg:

    ALTER TABLE T1 NOCHECK CONSTRAINT ALL

    After loading the data may be you can reset the constraints

    ALTER TABLE T1 CHECK CONSTRAINT ALL

     

    For the identity columns , may be you can set the identity_insert off

    Eg :

    SET IDENTITY_INSERT T1 OFF

    Hope this Helps !!!

    Meghana

     

     

     

     

    Regards,

    Meghana

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

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