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 |
|
jeffbond
Starting Member
16 Posts |
 Posted - 2009-01-21 : 08:24:37
|
| Hi,I have 2 questions :1. How can I export all of the DBs from my mssql server?2. Once I have exported the dbs to server #2, how can I schedule an update of the data from server #1 to server 2# BUT only the data that has been modified.Thx |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2009-01-21 : 08:34:47
|
| 1. You can take a backup of all the DBs on server 1 and restore them on server 2.2. You can set up transactional replication between the two servers so that modified data will get reflected on server 2.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-21 : 08:41:49
|
| You can directly use transactional Replication for required contents which will migrate and replicate as well. |
|
|
|
|
|
|
exporting dbs