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 |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2003-03-10 : 00:48:34
|
| Hi,we have 10 servers in different locations(All over the world). From all locations data is Inserted, Updated and Deleted. End of the day data goes to two main locations from other 8. And in the morning again data goes from 2 main locations to all other 8.We have some rules for overruling data, depending on locations and columns affected.Right now we have one application which do all these things. We want to make it fully automated from back end. Which option is good? Replication or DTS? It should handle all overruling rules.Thanx in advance.---------------------------Sandesh - The Messanger |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-10 : 02:17:46
|
| I'm not a great fan of replication or DTS.Can you transfer the data via remote procedure calls? Or bcp the tables out copy the files and bcp in or use sql-dmo.Whatever you do keep the data transfer separate from the updates - this will make it a lot easier to test and makes it easy to change the transfer method if your network changes.Get the data into tables on the local server then run SPs to update from them. In this way you will be able to back up the received database to have a record of what has happenned.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2003-03-10 : 04:04:46
|
| Thanx nr...We are planning to update data on hourly basis. If we call remote procedures, will it affect on speed of the server? Which server will get affected most? The sender or Receiver?---------------------------Sandesh - The Messanger |
|
|
|
|
|
|
DTS, Replication Or Front End?