C# Syncing data between SQLite and SQL Server

Question

I'm designing a small piece of software for a company. Basically, they need to manage a large list of items. Edit, delete, and so on. Basically, I'm storing the data INITIALLY in SQLite locally on their computer. Once they get done modifying the "list" items, they will need to be synced over to the SQL Server database on the production server.

What would be the most reliable way to sync data between the databases? I'm also going to be storing small images for each item. I'm estimating anywhere between 1000~5000+ items within the first month.

Can I do this all via SQL? Or do I need to convert the SQLite database to another format? Or pull the data from the SQLITE DB, and manually sync it?

What is the reason you want to use SQLite? Can't you store it in the MSSQL database, just in a different set of tables? — Andrew Savinykh
– Andrew Savinykh, Commented Jun 10, 2011 at 4:50

marc_s · Accepted Answer · 2011-06-10 04:57:06Z

2

Have you considered using SQL Server Compact Edition v4 (on .NET 4) instead??

It would support T-SQL front to end, and it's just as easily deployable as SQLite. It's "in-proc", e.g. just a fine DLL's to include in your project, it stores everything inside a single .sdf file, it needs no server install, no runtime other than .NET 4......

See:

answered Jun 10, 2011 at 4:57

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Johann Blais · Accepted Answer · 2011-06-10 05:20:35Z

0

You can have a look at the Sync Framework, it looks like it is exactly the kind of problem it is supposed to solve.

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

answered Jun 10, 2011 at 5:20

Johann Blais

9,4596 gold badges50 silver badges66 bronze badges

1 Comment

Johann Blais Over a year ago

One way or another it will. AFAIK there is not builtin support but there is an open-source project for that: sourceforge.net/projects/sqliteclientsyn

Collectives™ on Stack Overflow

C# Syncing data between SQLite and SQL Server

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related