Click here to Skip to main content
15,886,756 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
My Server is having MS SQL Server 2012,
My Application use SQLlite,

How Connection Can Be establish BTW SQLlite amd MS SQL Server ????
Posted

1 solution

You don't, generally.
If your app uses SQLlite, then it's a single user database system.
If you need to integrate that info with a multiuser SQL server DB, then exactly what to do depends on how your app is being used.
If it's always on the LAN and can access the SQl Server instance, then change you app to use SQLConnection, SQLCommand, etc. objects instead of the SqLite eqivilents (SQLiteConnection, SQLiteCommand, etc.). Pretty much, it'll work unchanged, provided you designed the app right in the first place.
If it isn't, then it's a seriously major job. Start by reading up on Database replication: MSDN[^]
 
Share this answer
 
Comments
sekharsam 10-Apr-15 7:24am    
thanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900