Most efficient way to move a few SQL Server tables to SQLite? -


I have a large SQL Server database; I want to dump 4 tables and dump them directly into sevette DBS (through night batch).

I was about to write a script (kicked through a UNIX host cron); But there should be a simple way to export tables directly (SQLite, there is no option in the DTS import / export wizard included)

The most effective to dump SQLite SQL Server tables through batch What will be the way

If you were considering DTS, then you can do this through ODBC. MSSQL -> ODBC -> Sequoite


Comments