Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Sync Access Database table to SQLCE table

Answered Sync Access Database table to SQLCE table

  • Friday, February 01, 2013 7:11 PM
     
     
    Sign In to Vote
    0

    OK, I have a WindowsForms application that uses a SQLCE for user data storage. I also have an Access Database (On network) that I would like to use as a data source. I am looking to sync a table from that access database to a table in the SQLCE database.

    Is this possible without looping through all of the data?

    It would be cool if I could query the Access database into a dataset object, and merge the two with one statement...

    Thanks,

    neech

    neech

     

All Replies

  • Monday, February 04, 2013 12:37 PM
     
     Answered
    Sign In to Vote
    0

    There was once a product similar for waht you're looking for but was inteded for SQL CE 3.0 on mobile devices - http://www.microsoft.com/en-us/download/details.aspx?id=17356 - and I don't believe that it's still supported.

    If you think that the sync logic is simple to implement you may develop it yourself, otherwise you'll have to look for another database engine. Without knowing more about the data to be synchronized, if it can be put on a cloud DB or if you're available to purchase a paid edition of SQL Server I can't give you any sugestions.

    Alberto Silva Microsoft MVP - Device Application Development - http://msmvps.com/AlbertoSilva moving2u - R&D Manager - http://www.moving2u.pt

     
  • Thursday, February 07, 2013 12:02 PM
     
     
    Sign In to Vote
    0
    You can import the table from MS Access using SDF Viewer into SQL CE 3.0/3.1/3.5/4.0 databases on the desktop.