SQL Mobile Merge Replication Questions?

[iKiLL]

Hi all



I have managed to setup the entire environment and get some C# CF code to
sync to the Database and use filters.

I could not have done it with out the help of these news groups. So thanks
to all.



I now have a few more question regarding different topics to do with syncing
I was hoping someone may know the answers to.

My environment is SQL Server 2005 using C# CF2 to sync via Merge Replication
to SQL Mobile.



Questions:

1.. Is it possible to display a progress bar during the initial
Synchronization and Database creation on the PDA.
2.. Is it possible to Run the Synchronization in a separate thread.
3.. If I can sync in a separate thread how would that effect the Updating
Inserting and deleting of records? Do I need to be concerned about table/row
locking?
4.. Can I get the Replication object to pull down just the Database schema
and create the database the first time. (I was thinking of doing this while
a splash screen was up.)
5.. If I specified a Host Name that did not exist in the Publisher
database would this solve question 4 buy bringing down the Database with no
data.
6.. Is Merge replication already compressed by default or do I need to
change a setting to get it to work?


Thnaks

ink

 

[Guest]

1. Yes, you can use BeginSynchronize() on the SqlCeReplication object. There
are many callbacks you can use to help with progress.
2. See 1.
3. You should not write to the db while synchronization is going on.
4. Not sure what you are getting at.
5. The host name (from my understanding) is used for filtering.
6. If I remember right, there is a compression level that defaults to 1.
This can be changed with the SqlCeReplication object.

 

[iKiLL]

Thanks Byan


I will do some reading on the BeginSynchronize() method.

Question 4 has come up because my client is currently syncing over GPRS and
using XML files to store the data.
i am upgrading them to use Merge Replication and SQL mobile. As they are not
going to move to 3G for a few more monthes i was hoping i could download the
database while i have a splash screen up and then sync the data when the try
to log on to the application. there for giving the appearance of a fast
First time sync.

Thanks for your input.
ink