Syncing SQL DBs

Izi

Izi

Izi

Soldato
Joined
9 Dec 2007
Posts
2,718
Sorry for noob-esk question, but is it possible to sync a database? IE I would like live enviroment to sync to dev enviroment daily.

Many thanks
 
Which Database technology are you using? MS SQL Server?


Regardless of technology you can simply restore your latest production database backup into the development environment and it should work.

Alternatively look at your RDBMS's replication technology.
 
Last edited:
Yes sorry, it will be MS SQL 2000 to MS SQL 2000, and eventually 2008 to 2008.

yeah, I know how to restore/backup - just want to automate it.

I think replication is the most similar thing I can compare what I want to do. However, i do not want to delete something locally whilst testing for it to delete on the live server, which i beleive is what would happen with replication?
 
Last edited:
Easily possible, though there may be some licensing issues lurking - log shipping works well for us though. Swapping to make the backup server live is pretty quick but it's not really designed for what you want - I think for that I'd just script a backup and restore to run daily...just simpler...
 
You must log in or register to reply here.
Back
Top Bottom