application. I want to have a desktop database that is kept in sync
with a handheld database, with updates occurring on both ends. To keep
them synchronized, I am investigating the use of both RDA and
Replication. I've gotten RDA to work, but have found a major drawback:
Every time you sync, you have to basically pull down a new version of
ALL the data, not just the changes.
So I started to look into
using Replication. If I understand correctly, using Replication, you
can do synchronization where only the changes have to be exchanged
between the handheld device and the desktop computer. But as I just
found out from the above post, you cannot create a Publication using
SQLExpress.
Why do I want to use SQLExpress? Because I need a
version of SQL Server that I can distribute for free with my
application. Am I wrong, or is SQLExpress that only one that has a free
redistributable?
Taking a step back, am I missing something? Is there a better (simpler?) alternative to RDA and Replication?
Thanks for any advice!
Tom
Hi Tom,
SQL Express is the only free version of SQL Server 2005, if you want to use Replication to synchronize you mobile database you will have to puchase one of the larger versions of SQL Server.
Mike
No comments:
Post a Comment