How to access sql database from sql mobile database?

• ramesh-734926

  Old Hand

  Points: 348

  More actions

  May 5, 2008 at 1:07 pm

  #380317

  I have a sql-server database table and I have a sql mobile database with a .SDF extension, I want them to speak to each other by being able to write queries form the mobile database to access sql data and insert it into the mobile database, how do I do it?

  Please advise.

  Ramesh

• Rajesh Patil

  SSC Veteran

  Points: 219

  More actions

  May 6, 2008 at 2:18 am

  #811061

  There are three options available .

  Remote data Access: Low data Load High frequency of Sysnchronisation

  Mege Replication: High data Load. Low frequency of Sysnchronisation.

  Web services : Where Constant conectivity desired.

  For a Sample application download : PocketVision from MSDN and and another one on RDA and Merge Replication.

  Regards

  Rajesh