How to Synchronize .sdf Database to .mdf Database & .mdf Database to .sdf Database?

Question

I have a project running on the tablet device which has .sdf file as database.

Now the database is set into the server for normal devices(Pcs).

How can i synchronise the data between .sdf file and .mdf file(server to .sdf file)

Any ideas will be appreciated.

Answer 1

am assuming you want to synchronize the contents of your SQL Compact SDF file to SQL Server rather than synchronizing the files themselves.

Have a look at: Tutorial: Synchronizing SQL Server and SQL Server Compact

or Walkthrough: Creating an Occasionally Connected Application