Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Syncing Production and Development Databases

Author  Topic 

mishaeljpradhan
Starting Member

2 Posts

Posted - 2012-02-23 : 01:10:03
I'm working in SQL Server 2005 (Dev) and I need to sync this database with the one in Production. Production data keeps on changing every month due to monthly data processing and manual syncing is getting tedious. I'm not talking about third party vendors who will do the job for me, but like, an ETL package or something.
Help me out guys

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2012-02-23 : 01:19:31
Periodic backup and restore will be easy way to do this..

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008
Go to Top of Page

mishaeljpradhan
Starting Member

2 Posts

Posted - 2012-02-23 : 23:44:33
You mean like a complete delete and full load of whatever is already there in my dev box?
Go to Top of Page
   

- Advertisement -