My first suggestion is break down your problem into smaller pieces.
* Step 1 - Connect to SQL Lite from c#
Google[
^]
What is the best way to connect and use a sqlite database from C# - Stack Overflow[
^]
Using SQLite in your C# Application[
^]
Getting started with SQLite in C# – Tigran's Blog[
^]
* Step 2 - Connect to Sql Server in c# - This is ridiculous well documented so I'll just leave you with a google search
Connect to sql server c#[
^]
* Step 3 - Run queries against sql lite, store the results in a list
* Step 4 - Take results from sql lite, and insert them into sql server
You also have other options as well. I'll leave you with google results you should have searched for.
sync sqlite and sql server[
^]
http://www.codeproject.com/Questions/869187/How-to-sync-between-sqlite-and-remote-ms-sql-serve[
^]
Something from this answer should provide you with what you need. This isn't necessarily a quick task so you will have to put some effort to it and expend a little brain power to make your two DB's communicate with each other. Now if you get into your merging and have an issue, feel free to come back with a clear explanation of your issue and some code samples (if applicable) so that way we know that you've at least attempted to tackle this problem.
Submit an article or tip