February 7, 2007 at 7:17 am
I want to refresh all the tables of SQLServer2005 database. Both the source and the destination database are in different server, although both running SQLServer 2005. When I tried IMPORT/EXPORT Data wizard I keep getting error Table already exists. The thing is in my destination database I have several Stored Procedures so I can't drop the existing tables.
Please suggest.
February 8, 2007 at 7:48 am
Import/Export will not try to create a new table if the table is already existing, however if there is some integrity problem then you may get some errors, so drop the constraints on the destination tables and rebuild them after the Import/Export process is completed.
Prasad Bhogadi
www.inforaise.com
February 8, 2007 at 8:54 am
Thanks for the reply. However this is how I got it done..
Instead of using SQLServer 2005's Management Studio I started the data import from Enterprise manager of SQLServer 2000 and selected the correct Host and Destination and without any error the data transfer completed.
Oh well ...some times undocumented things work !!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply