Does anyone know of a tool to migrate a Sqlite database to SQL Server(both the structure and data)?
Thanks?
+1
A:
sqlite does have a .dump option to run at the command line. Though I prefer to use the SQLite Database Browser application for managing sqlite databases. You can export the structure and contents to a .sql file that can be read by just about anything. File > Export > Database to SQL file.
swilliams
2008-10-02 15:48:54
The exported file does need some tweaking for diferences in syntax but nothing too complex. Thanks
geoff
2008-10-02 16:09:53
+1
A:
The Sqlite .dump command will output the entire contents of the database as an ASCII text file. This file is in standard SQL format, so it can be imported into any SQL database.
More details on this page: sqlite3
I don't know how the import is done in SQL Server; perhaps someone can edit this post with specific instructions?
Nathan Clark
2008-10-02 15:51:57