On 27 Feb 2013, at 3:10pm, levi <levi.silva.men...@gmail.com> wrote:
> More precisely, I want to create a sqlite database based on a few tables and > data from the Sqlserver database. Good solution: Have your SQLServer database software generate a set of SQL instructions for making the database and inserting data into it. Then use the SQLite shell tool to create a new database using the '.read' command and this file as input: <http://www.sqlite.org/sqlite.html> <http://www.sqlite.org/download.html> (look for 'shell' for your platform) Not quite as good: Have your SQLServer database software generate either Tab-Delimited or Comma-Delimited data, and import that into a SQLite database which has tables already existing. You can use the same shell tool yourself to create the SQLite database with empty tables in it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users