Export data Identity Column Problem
Posted on 2007-11-17
I want to export data from my remote server to my local machine. I want an exact copy. The problem is that I can export data from remote dbQIIHL to local dbQIIHL but since I have identity colums the export doesn't override the identity column constraint on my local machine, hence my sql queries do not work on the local machine after the export process.
Is there a way to turn off the identity on a database, do the export, and then turn it on again so that the db behaves normally?