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 |
|
hadoft
Starting Member
20 Posts |
 Posted - 2003-08-24 : 13:07:35
|
what is the ideal scenario to handle this very common (as i think) case through replication (I am planning to use merge replication)company has three separate stores all stores sell the same materials exactly, so i want new materials to be added at company office then synchronized to every store(i am using uniqueidentifier for PK and FK)then every day we want to get the new transactions to the company through dialup connectionand i want to use windows synchronize to do the synchronization, because it is simplifying very very mush the establishing of dialup connection and the ability to schedule the process to be done automatically at night, and any almost any employee can easily learn to use it but I was very very sad when i knew that windows synchronizer doesn't supportpush subscriptions which I was planning to use, and supports pull subscriptions only is it recommended to synchronize the three store databasesto a single database in the company officeor define a separate database for every store (I think I prefer this more) ??how do I handle the material cards distribution??I am planning to create a separate database that holds only materials and common tablesso i can define the new materials in it then synchronize it with every store database (at company server) then at next sync with store the new materials will be copied to store database (is it a good idea ??)in summary I will have 7 databaseone in every storethree at company, every one is mirror of one store dband one to hold the shared information (materials, main classifications, ...)- what is you opinions about all above?- is there any way to link push subscriptions to windows synchronizer, or any other similar tool?- what type of subscription most preferred ? - Between the main db and every local store dbs - Between every local store db and far store dbIf I needed to make reports for sales on the three stores together, can I make another db and sync? Every store db to it.And thank you very mush for your time |
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2003-08-24 : 21:34:09
|
| G'dday hadoft,As you mentoined the scenario is very common case to use replication. In your case, I would recommend you to use a mixture of Merge and Snapshot Replication.So letz start from the basics and try to work out one issue at a time.Issue 1: What kinda replications is best Suited in this scenario?A: Merge Replication to syncronise the daily transaction data and Snapshot Replication to syncronise the Static data (to handle material card distribution). I recommend you should use compressed snapshots to distribute such data. More info on the replication types in BOLIssue 2: How many database should be created to cater for the whole Scenario?A: I would create 2 databases on the Central Company Server (1 to hold the transactional Data and 2. to Hold the Static data ie material Card distribution). And you can create 1 publication on each. Merge replication supports partioning of the data so that would remove the need to have seperate database for sync for each site. This will reduce your maintaince task a lot.Issue 3: Reporting Issue?A: If you adopt the approach in Issue 2, you dont need to create a new database for reporting purpose. The trick would be to run the reports of the central database for all the three sites. Issue 4: Syncronisation using Windows Syncroniser?A: I havent used much of the windows Sync. for replication. But the other approach could be to create a small VB app using the Replication Control lIbrary and Syncronising with teh central Server on demand or at a particular time of the day. (This approach would allow you to set Push or Pull Subscription). I will look into the Windows Sync manager and update the forum shortly.At this point I think the info is more then enough for you to analyse and get started with it.Should you require detail on anything let us know.HTH,Samrat |
 |
|
|
|
|
|
|
|
replication scenario, please help