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 |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2007-05-04 : 15:33:13
|
| Hello,Say there are 10 retail store locations that need to push their daily sales to the main server at the head office.What techniques are used to accomplish this? I'd imagine the transaction rows would have to be some sort of a GUID.What options are there? What techniques are used to ensure each stores orders have indeed been pushed to the main server? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-04 : 15:36:31
|
| Well you'd use replication, perhaps merge replication.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2007-05-04 : 16:17:20
|
| It seems something like this can be done with C# and a windows service, and probably have more room for customization no? (i've never touched replication before). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-04 : 16:32:27
|
| I'm not sure why you'd want to reinvent the wheel. Replication can do this for you. Let us know if you have specific replication questions.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
multiple stores orders to sink up with main server