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.
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