Geek Answers Handbook

C # Data Sync between SQLite and SQL Server

I develop a small piece of software for a company. Basically, they need to manage a large list of items. Change, delete, etc. Basically, I store INITIALLY data in SQLite locally on my computer. After they are modified elements of the "list", they will need to be synchronized with the SQL Server database on the production server.

What would be the most reliable way to synchronize data between databases? I am also going to store small images for each item. I rate somewhere between 1000 ~ 5000 + items in the first month.

Can I do this through SQL? Or do I need to convert the SQLite database to a different format? Or pull data from a SQLITE database and manually sync it?

+4
source share
2 answers

Did you think you were using SQL Server Compact Edition v4 (on .NET 4) instead?

It will support T-SQL to the end, and it is as easy to deploy as SQLite. This is in-proc, for example. just a thin DLL for inclusion in your project, it stores everything in a single .sdf file, it does not need to install a server, there is no runtime other than .NET 4 ......

Cm:

+2
source

You can take a look at the Sync Framework, it seems that this is exactly the problem that it should solve.

http://msdn.microsoft.com/en-us/library/bb902854.aspx

0
source

More articles:


All Articles