mercredi 13 janvier 2016

how to Import data from one Sqlite database to another Sqlite database using c#

I want to use same windows c# application on two systems.I want to backup my Sqlite Database from one system and then I want to use same database on another system. I am able to take backup of database using C# code but I am not able to import that database in same windows application on another system. How to import data from one Sqlite database to other using C# code on a button click. And is it proper way to use following query

INSERT INTO X.TABLE(Id, Value) SELECT * FROM Y.TABLE;  

Aucun commentaire:

Enregistrer un commentaire