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.
| 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 2008MCTS - Database Development SQL SERVER 2008 |
 |
|
|
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? |
|
|
|
|
|
|
Syncing Production and Development Databases