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 |
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
 Posted - 2008-09-20 : 01:47:47
|
| 5+ tool stores.1 main office. 5+ tool stores send their data to main office daily.5+ tool stores want to have their data synchronized.what can i do in order to accomplish this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-20 : 02:04:17
|
| How frequent will data be sent. Also how frequent you want synchronisation to happen? |
 |
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-09-20 : 02:14:43
|
| How frequent will data be sent?daylyAlso how frequent you want synchronisation to happen?dayly |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-20 : 02:24:55
|
quote:
Originally posted by lamujerdetuhermano10
How frequent will data be sent?daylyAlso how frequent you want synchronisation to happen?dayly
once a day? |
|
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-09-20 : 02:31:29
|
| yes |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-20 : 02:39:47
|
quote:
Originally posted by lamujerdetuhermano10
yes
I think what you need is merge replication.refer the below articlehttp://www.databasejournal.com/features/mssql/article.php/1438231 |
|
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-09-20 : 03:12:14
|
| Is this what banks are using? I want to do something like the banks. Like i go into a branchA to open an account then go to branchB and branchB should immediately have my info. But i want to do this daily not in real time. |
|
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-09-20 : 16:16:12
|
| merge replication 2005 is deleting my records from the subscriber. is there a way to keep the records? |
|
|
|
|
|
|
share data