Merge Replication - First Sync to Long?

  • Thread starter Thread starter iKiLL
  • Start date Start date
I

iKiLL

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
 
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 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
 
Back
Top