Link to home
Start Free TrialLog in
Avatar of Paduwan
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.
Avatar of Jaime Olivares
Jaime Olivares
Flag of Peru image

Are you using backup and restore options?
Just remove all the database tables manually and restore the database. Release database must exist (empty) with the same name as the test database
Avatar of Aneesh
use BACKUP RESTORE method instead of exporting the data.
Avatar of Paduwan
Paduwan

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?
ASKER CERTIFIED SOLUTION
Avatar of Jaime Olivares
Jaime Olivares
Flag of Peru image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Paduwan

ASKER

Thanks for your help everyone. Points to Jaime.