identity insert in "export data" RRS feed

  • Question

  • Hello,

    I have to transfer some data between 2 DB (about 200 tables). I plan to use the "export data" feature of SQL Server Management Studio.

    Everything is fine with this tool, except I have to keep the identity values in tables, and I don't want to edit the 200 table mappings in the "export" tool, to set the "Enable identity insert" checkbox.

    Is there a way to enable that for the whole process ?

    Thanks for your help & time...


    Wednesday, December 21, 2005 7:45 PM