Import and Export Wizard with Identity Column

I  want to move data from one DB to another, while keeping the identity column values in the old DB. When I run the wizard I get a validation error "Failure inserting into the read-only column "UID".

Where UID is an identity column on that table. How can I override the identity functionality in order to be able to import the data?

Answer  : By Enable identity insert. There's a check box when you click the Edit Mappings.

Share this: