Friday, February 01, 2013 7:11 PM
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...
Monday, February 04, 2013 12:37 PM
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
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Wednesday, February 20, 2013 9:44 AM
Thursday, February 07, 2013 12:02 PMYou 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.