Friday, March 23, 2012

Reflecting changes in production Db onto staging DB

I have a database db1 on server1 and server2.The Db On server1 is a production db and the Db on server2 is a staging Db.All the new data will be coming into production Db.And i wanted to update the data and database structures on staging Db from production Db on weekly basis.So how can I reflect the data and datastructures on my staging Db from my production Db.

Thanks.I'd recommend backup and restore. I've never found anything else that completely satisfies me.

-PatP

No comments:

Post a Comment