Sync between Local SQLite and Remote SQL SERVER

Question

Hello Experts,

I have SQLite installed in my machine and i have a remote database server.

I have installed ODBC drivers of sqlite in my machine and created databases in my machine and i want to sync up with remote database server by using linked server option.

But im facing the below error

And same thing i have tested in database server (Installed sqlite and odbc in database server) and test connection is successful.

I'm just looking any kind of free tool and script which automate the sync between sqlite and remote database server ?

Thanks

---

Ram

Answer 1

I don't know anything about SQLLite, but I suggest you try this method: https://www.mssqltips.com/sqlservertip/3087/creating-a-sql-server-linked-server-to-sqlite-to-import-data/

There is nothing built in to sync SQLLite with SQL Server.  You will need to write queries and insert/update/delete/merge commands to sync what you want.

Answer 2

I believe this is not possible. You cannot just sync arbitrary MS SQL Server database to SQL Lite file as they have differences in data types, query languages, etc. This is the same as trying to shrink word document to text file. The text may be retained, but no formatting, pagination, fonts, images. etc. 

Answer 3

It's not clear to me, but do you want to sync your local SQLite with the remote SQL Server instance by means of a linked server?

I would not expect that to work. As I understand it, SQLite is a file-based database, so all access is directly to the file. In difference to SQL Server, there is no server that you talk to. You could have the remote SQL Server instance access your disk, if you create a share and put the SQLite database there, but that does not seem like a good idea to me.

I think your best bet is to write a program in C# or whatever language you prefer to read from the SQLite database and talk to the remote server instance.

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Answer 4

Hi Ram,

Please have a try with Connecting SQL Server Management Studio to SQLite via ODBC Driver.

In addition, you could try to use SQLite/SQL Server Compact Toolbox(Download) which will create, manage, develop and maintain embedded database solutions using SQLite and SQL Server Compact with this free suite of tools and libraries developed and maintained.

Then you could create and manage both Merge Replication subscriptions and Sync Framework provisioning/code generation.

More information:SQLite and SQL Server Compact Toolbox

Best regards,

Melissa

-------------------------------------------

MSDN Community Support

Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact [e-mail]

Answer 5

Hi Ram,

This thread has been around for several days. Please remember to mark the replies as answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread. 

Thank you for understanding! If you have any question or update, please feel free to let me know.

 

Best regards,

Melissa

-------------------------------------------

MSDN Community Support

Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact [e-mail]