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.
PaduwanAsked:
Who is Participating?
 
Jaime OlivaresConnect With a Mentor Software ArchitectCommented:
For a real time replication use Mirroring feature, have a look to this tutorial:
http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=213&rl=1
0
 
Jaime OlivaresSoftware ArchitectCommented:
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
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
use BACKUP RESTORE method instead of exporting the data.
0
 
PaduwanAuthor Commented:
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?
0
 
PaduwanAuthor Commented:
Thanks for your help everyone. Points to Jaime.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.