4

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?

Kiquenet
  • 14,494
  • 35
  • 148
  • 243
Thomas
  • 41
  • 1
  • 2

2 Answers2

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:

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
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

Johann Blais
  • 9,389
  • 6
  • 45
  • 65
  • 1
    One way or another it will. AFAIK there is not builtin support but there is an open-source project for that: http://sourceforge.net/projects/sqliteclientsyn/ – Johann Blais Jun 10 '11 at 05:25