query between SQL Compact 3.5.1 and SQL Server 2008 R2

• Dominic Gagné

  SSCrazy

  Points: 2654

  More actions

  July 8, 2014 at 8:16 am

  #287785

  Hi,

  I have a SQL Compact database, located on a mobile device, that needs to be sync with a SQL Server 2008 R2. Only some rows not present in the Compact database have to be copied.

  is there a way to do a SELECT between those database in Management Studio?

  thanks a lot for your time and help