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

Reply via email to