Setup database from scratch

Jul 12, 2013 at 11:01 AM
Thanks for the excellent project, it is exactly what i am looking for...

However, to setup the database and generating those files are not very clear, Iooking at the sample project, I assume the following steps?

1) create the SQL compact database
2) create a sync configration xml file
3) using the syncsvctool to generate the two class files

so the server will use SQL CE database instead of SQLite?
Jul 17, 2013 at 2:12 PM
There is no SQL Compact Database in the sample
  • Server side : It's a SQL Server database, acting as the server for all clients
  • Client side : It's a SQLite database, which can work with a Win8 tablet or a WP8 phone
For both of them, only one xml file is required. With this xml file, you will generates the server files and the client files.

Don't hesitate if you have any questions (or if my answer is not good :))

Sébastien PERTUS
Jul 18, 2013 at 11:35 AM
Thanks for the helpful answer, now the neow w question here :)
I implement a simple client server sync, it is working!!!
But seems like the sqlite database at client always created based on the server side SQL Server DB, can I use a existing client side sqlite database, and make it sync with server side?
Jul 23, 2013 at 8:52 PM
I think you can do it this way. But I've not test this case, do you have any issue or is it working as expected ?