May 27, 2009 at 7:38 am
I have a database sql 2005 that I created and exported last week from server A to server B and everything went well for testing. Now that I need to refresh the database (the application vendor has requested for import/export instead of other methods, detach/attach, restore), if I import the whole database using Import/Export wizard from A to B , it will duplicate the data in server B, right? or even give me error. Is there any way to overcome this easily in the wizard? or do I have to DROP last week's created database (drop database serverA) and recreated the whole database and import the database again?
Any suggestion would be appreciated.
thank you
May 27, 2009 at 8:39 am
When you use the Import/Export wizard, you have the option to append or replace the data ("edit mappings"). You have to go into each table to set it which can get tiresome if you have a lot of tables . Also, identity columns will give you an error unless you check the box to enable identity insert.
You may also get errors if you have referential integrity.
Why does the vendor care how you do it ? Backup & restore or detach are so much simpler, and you get everything, but will probably have to re-do permissions.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply