3 grudnia 2009 11:02
I am using sync framework 2 and want to sync a local database, that’s used by my desktop application and sync it to a sql server 2008 database on a web server over the internet.
Ok i know when using the wizard in vs2008 the client database gets setup with all the data that you specified in the wizard and thus can synchronize, what i want to find out, is there any way to set UP this sync process without the client database needed to be filled with records from the sql server .
I need this behavior because the original data gets converted from access database(from legacy program) to the sql ce database which then needs to be synchronized to the server, there is about 30 client applications that syncs to the same sql server 2008 database.
Hope someone can help
Ready for the Future
4 grudnia 2009 07:47WłaścicielYou can always edit the SQL queries to not get the data but instead just get the schema if you want.
Also another note is that VS 2008 uses the older set of providers we had built for data synchronization and it does not use the Sync Framework per se.
So if I understand your scenario right, you want the 30 clients to sync one way to the central server.
If so, as I said above, start with the VS2008 sample code and then based on that, you can create new client and server code to do upload only syncs to your SQL Server.
Hope that helps.
This posting is provided AS IS with no warranties, and confers no rights