April 13, 2006 at 4:59 am
Am trying to use the Import Data wizard in Mgt Studio to get data from a local 2005 database into a remotely hosted 2005 database. Hit issue with importing into an identity column and understand that way round this is to use a 'keep identity' qualifier - but have no idea how to do this using the wizard.
Jon Stranger
April 13, 2006 at 5:42 am
In the Wizard, when you are specifying the mapping between tables from the Source to the Destination, click on Edit and check the check-box that says "Enable Identity Insert".
April 13, 2006 at 10:10 am
Many thanks - silly of me to miss that!
Jon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy