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 |
|
richardwaugh
Starting Member
36 Posts |
 Posted - 2012-07-12 : 09:13:19
|
| Hello,I was wondering if there is a way to update data from one database to another automatically. Basically what I need to do is update our training database with our production database. However I need to do this on a daily basis would prefer to have it done automatically. The two databases are located on different servers as well.Is this possible? I've been experimenting but don't want to dig in too much further and risk messing up the production database.Thanks,Richard |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2012-07-12 : 09:45:37
|
| Sounds like replication is what you want.EDIT:well, maybe not. Perhaps an automated process that takes your daily production backups, copies them to your training environment and then restores them. Log shipping is another possibility to consider.Be One with the OptimizerTG |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-12 : 10:13:00
|
| you want it to happen at realtime or at frequent intervals? have a look at replication in MSDN------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Automatic Data Update