Merge Replication - First Sync to Long?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

iKiLL - 19 Mar 2007 14:41 GMT

Hi all

I am developing a C#, CF2 and SQL Mobile app.

I have the Merge replication all working well.

The problem is that the First Sync when the Database is created on the
Device takes a long time.

Is there some trick that any one might know to speed this up?

Something like Deploy a Blank Snapshot with the application then it can just
make the schema changes it needs and bring down the data. If this is
possible?

I am already compressing the data.

Thanks
ink

Reply to this Message

Bryan - 19 Mar 2007 16:05 GMT

You can build the initial database file on a desktop and then upload it to
the device. The only thing you need to keep in mind with this approach is
the passwords that are encrypted in the subscription in the .sdf file. They
are encrypted with a key that is unique to a machine. On the device, you can
load the subscription information, set the passwords, and then save. This
will reencrypt the passwords, and all will be good.

> Hi all
>
[quoted text clipped - 15 lines]
> Thanks
> ink

Reply to this Message

iKiLL - 19 Mar 2007 18:05 GMT

Hi Bryan

Thanks for your input.

When you say create an internal DB, do you mean with in the Solution.

Cos my clients are syncing over GPRS not Active Sync.

Thanks.
ink

> You can build the initial database file on a desktop and then upload it to
> the device. The only thing you need to keep in mind with this approach is
[quoted text clipped - 25 lines]
>> Thanks
>> ink

Reply to this Message

Merge Replication - First Sync to Long?

Free Magazines