Post reply

Copy data from one Server to other

  • December 10, 2009 at 3:56 am

    #218630

    Hi,

    I need to copy all the tables from one server to other.

    I am using SQL Import/EXport wizard.

    My Table has a KEY coulmn(autogenerated )

    This column is giving different values when I copy the data with the Wizard.

    How can I get the exact copy of the table?

  • December 10, 2009 at 4:25 am

    #1090443

    Did you try setting "Enable Identity Insert" on the "Mapping" tab ?

  • December 10, 2009 at 3:28 pm

    #1090908

    It may be easier to restore from a backup.

    Joie Andrew
    "Since 1982"

  • December 10, 2009 at 10:39 pm

    #1090995

    Thanks for the help....

    Tried Enabling Identity Insert and it worked..

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

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