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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Is this merge replica model possible?

Author  Topic  lottoman Starting Member 1 Post Posted - 2005-05-17 : 12:41:38 Hello All, I have this model in mind. That is presented below. I am presenting 2 scenarios. Day 1 to day 7, cover scenario 1, and Day 9 covers scenario 2. Day 1. A user subscribes and downloads subscription X. The user works -off line- on his locally cached data Day 5 The same user decides that he wants to update the local subscription he has got from day 1. Without having to (check-in) synchronize with the server. Just pure update of the locally cached (data) subscription. You can assume for simplicity the delta will cause no collisions with the locally cached data. Day 7. The same user is happy with his work, so he synchronizes (merges) back with the server. Assume all collisions (if any or no collisions at all) are resolved. Day 9. The same user decides to work again. So he re-initialize with the server. Can we be selective, say the server – based on history- figures that the user has pretty much 90% of all the data he needs and instead of downloading a fresh version, it downloads a delta instead. You may ask why is that? Ok, What we have is a huge replica, say in 100,000+++ records. And our users can be connecting using modems. We don’t want to waste time downloading that amount when all changes that occur were the addition of 1000 records to the database. So basically, if I downloaded on Day 1 100,000 record and on day 9, the replica would have included 100,1000 records - assume no collision for simplicity-. All I want is those 1000 records added to my 100,000 that are locally cached from Day 1. Q1: Is this model a total variant from the normal Merge Replica model? Q2: Is this model possible – built-in or by programming functionality it does not really matter. Q3: Can one download a delta (new records added to the database) to the local copy of the cached subscription from the server? Q4: Can we have a subscription that does not expire after synchronization (merging) with the server? Q5: What kind of data transfers can I utilize to expedite the replica transfer? My data is all ASCII. Can we compress the replica? Q6: Can we encrypt the replica after compression? Please be techinically specific if at all possible. Thank you sincerely so very much! . MSA