[sqlite] SQLite (SQ3) Interfacing with SQL Server 2005 Standard Edition.

2009-06-17 Thread David Cawley
Users, I have a requirement to have two separate databases, MS SQL Server 2005 Standard Edition and SQLite (SQ3) interface to avoid duplication of certain data. The preference of the project is to have the SQL Server 2005 database populated and then duplicate and insert data directly into

Re: [sqlite] SQLite (SQ3) Interfacing with SQL Server 2005 Standard Edition.

2009-06-17 Thread Roosevelt Anderson
I made a simple command line app that exports a MSSQL query to a sqlite table. This might not be exactly what you need but it should be in the ballpark. The app and the source can be found here: http://www.proghack.net/?p=40 On Wed, Jun 17, 2009 at 5:25 AM, David Cawley