Monday, May 17, 2010

Most efficient way to move a few MS Sql tables to SQLite?

Programmer Question

I have a fairly large MS-Sql database; I'd like to pull 4 tables out and dump them directly into an sqlite.db for remote querying (via nightly batch).



I was about to write a script to step through(most likely on a unix host kicked off via cron); but there should be a simpler method to export the tables directly (SQLite not an option in the included DTS Import/Export wizard)



What would the most efficient method of dumping the MS Sql tables to SQLite via batch be?



Find the answer here

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails