Paduwan
asked on
Trying to migrate SQL 2005 database
I have an SQL database on a test system, and a duplicate database on a production system.
I now wish to export the test system onto the production system. I am encountering an error stating that the tables already exist on the production system.
This is occuring using both "delete existing tables" & "drop and re-create tables" options.
I am trying to perform this via the SQL Management Studio.
I now wish to export the test system onto the production system. I am encountering an error stating that the tables already exist on the production system.
This is occuring using both "delete existing tables" & "drop and re-create tables" options.
I am trying to perform this via the SQL Management Studio.
use BACKUP RESTORE method instead of exporting the data.
ASKER
yes that's fair enough but in the future I will be testing changes on the test system, then taking them over to the production system.
Would backup/restore still be the best choice? Is there a way to force a replication?
Would backup/restore still be the best choice? Is there a way to force a replication?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help everyone. Points to Jaime.
Just remove all the database tables manually and restore the database. Release database must exist (empty) with the same name as the test database