• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

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.
0
Paduwan
Asked:
Paduwan
  • 2
  • 2
1 Solution
 
Jaime OlivaresCommented:
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
 
Jaime OlivaresCommented:
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
 
PaduwanAuthor Commented:
Thanks for your help everyone. Points to Jaime.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now