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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2002-06-07 : 08:21:18
|
| v writes "i have 4 identical copies of sql database , located on different locations , connected by WAN . one is master copy of database and 3 are trancation copies. due to bandwidth problem , databases are updated once in evening through batch transfer updation. first update the master database with all 3 database and then all 3 database updated. can any one help me how to do this process . please explain in detail with examples. if possible provide some sample code for this." |
|
|
dataphile
Yak Posting Veteran
71 Posts |
Posted - 2002-06-07 : 08:46:04
|
| You need to seriously have a look at DTS (Data transformation services). |
 |
|
|
|
|
|