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 |
|
rkhairi
Starting Member
4 Posts |
 Posted - 2006-05-09 : 03:50:42
|
| Hi,I need help in deciding which method to choose either DTS or replication or FTP text files and this is my scenario:- There are about 600 branches with minimum 9.6K connection to the HQ- There are multiple version of SQL; 6.5, 7.0 and 2K – HQ=2005- Every morning I need to transfer a data from HQ to every branch – very minimum data- Every 5 min I need to transfer transaction data from every branch to HQSo can you all help me by giving your expert advice which method should I choose?Your help is really appreciated.TQ. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-09 : 05:23:07
|
| when you say transaction data to HQ, is that all of 600 into one table? or one table pr branch?--------------------keeping it simple... |
 |
|
|
rkhairi
Starting Member
4 Posts |
Posted - 2006-05-09 : 06:18:42
|
| jen, 600 to one table.....is it advisable? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-09 : 10:27:24
|
| what is the purpose for HQ? is it for repository only, for merge reports or will they still undergo further processing?--------------------keeping it simple... |
|
|
|
rkhairi
Starting Member
4 Posts |
Posted - 2006-05-09 : 21:07:31
|
| at HQ the data will be merge and then sent to another system ie SAP and also kept for certain period for reporting. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-09 : 22:23:29
|
| i haven't seen this much source to one destination using replicationhow many rows do you expect HQ will receive from each branch?by the looks of it, an automated file transfer will be my bet, in dts, you will need uninterrupted connection atleast for the duration of the transfer, and if something happens and it gets cut off prepare for a longer rollbackeach branch will output the text file into the sftp site, then your HQ will retrieve the file and feed them into the table, you have an option to do it one table per branch or one to all, but the concern is the sheer volume of data that you need to retain and manipulateit's better to get the numbers straighten out before deciding which option will give you better performance and "recoverability" in case something happens to HQhope that makes sense...--------------------keeping it simple... |
|
|
|
rkhairi
Starting Member
4 Posts |
Posted - 2006-05-09 : 22:38:43
|
| thanks jen ya i think that is the best bet anyway thanks again.... |
|
|
|
|
|
|
|
|
DTS or replication or text files