I wrote a simple c# command line program that will import data from MSSQL into a sqlite database. You specify a query (for MSSQL), a connection string, the location of the sqlite database file, and a table in the sqlite database and the app dumps the results of the query into the table. You could easily use it in a batch file to accomplish what you need. If you want the app, I could send it to you.
On Wed, Nov 12, 2008 at 9:45 AM, Baskaran Selvaraj <[EMAIL PROTECTED]> wrote: > > > Hi All, > This is Baskaran and I am looking for a vendor tool to automate the import > process. > We have an application which is written to use SQLite database. Right now, I > import the data > into SQLite database from SQL Server 2005 manually. Looking for a vendor > software, which can used > to automate the process of importing the data from SQL Server 2005 to SQLite > database > on a daily basis > . > Thanks > Baskaran Selvaraj, DBA > > _________________________________________________________________ > See how Windows(R) connects the people, information, and fun that are part of > your life > http://clk.atdmt.com/MRT/go/119463819/direct/01/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
