Re: [sqlite] SQLite Import Tool

2008-11-13 Thread Baskaran Selvaraj
Thanks you all for your support. Finally, I was able to make SQLMaestro work. Thanks once again Baskaran> Date: Thu, 13 Nov 2008 10:14:14 -0500> From: [EMAIL PROTECTED]> To: sqlite-users@sqlite.org> Subject: Re: [sqlite] SQLite Import Tool> > Here is a link to the appl

Re: [sqlite] SQLite Import Tool

2008-11-13 Thread Roosevelt Anderson
MAIL PROTECTED]> To: sqlite-users@sqlite.org> Subject: Re: > [sqlite] SQLite Import Tool> > 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 sqlit

Re: [sqlite] SQLite Import Tool

2008-11-13 Thread Keith T
e.org> Subject: Re: [sqlite] SQLite Import Tool> > > > Hi> > You can use SQLite ODBC Driver and SQL Management Studio Data > > Transfer> Wizard to perform this action.> > On Wed, Nov 12, 2008 at 12:45 > > PM, Baskaran Selvaraj <> [EMAIL PROTECTED]> w

Re: [sqlite] SQLite Import Tool

2008-11-12 Thread Baskaran Selvaraj
Thanks roosevelt. I will try to use the c# command. > Date: Wed, 12 Nov 2008 15:03:41 -0500> From: [EMAIL PROTECTED]> To: > sqlite-users@sqlite.org> Subject: Re: [sqlite] SQLite Import Tool> > I wrote > a simple c# command line program that will import data from

Re: [sqlite] SQLite Import Tool

2008-11-12 Thread Roosevelt Anderson
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 e

Re: [sqlite] SQLite Import Tool

2008-11-12 Thread Thomas Briggs
I tried using DTS but the import process is taking hours > and most of the time it fails at the end with timeout. > >> Date: Wed, 12 Nov 2008 09:58:36 -0500> From: [EMAIL PROTECTED]> To: >> sqlite-users@sqlite.org> Subject: Re: [sqlite] SQLite Import Tool> > You ca

Re: [sqlite] SQLite Import Tool

2008-11-12 Thread P Kishor
nd databases. Good luck. > Date: Wed, 12 Nov 2008 11:12:04 -0600 > From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLite Import Tool > > On 11/12/08, Baskaran Selvaraj <[EMAIL PROTECTED]> wrote: > > > > Hi Donald, > > 1.

Re: [sqlite] SQLite Import Tool

2008-11-12 Thread P Kishor
tool, it takes like 30 minutes to import > all the data. > > Thanks > Baskaran > > Date: Wed, 12 Nov 2008 11:46:16 -0500> From: [EMAIL PROTECTED]> To: > sqlite-users@sqlite.org> Subject: Re: [sqlite] SQLite Import Tool> > > Greetings, Baskaran,> > Re

Re: [sqlite] SQLite Import Tool

2008-11-12 Thread Baskaran Selvaraj
data. Thanks Baskaran > Date: Wed, 12 Nov 2008 11:46:16 -0500> From: [EMAIL PROTECTED]> To: > sqlite-users@sqlite.org> Subject: Re: [sqlite] SQLite Import Tool> > > Greetings, Baskaran,> > Regarding: "SQLite ODBC driver takes hours for data > transfer a

Re: [sqlite] SQLite Import Tool

2008-11-12 Thread Griggs, Donald
Greetings, Baskaran, Regarding: "SQLite ODBC driver takes hours for data transfer and most of the time it is not success." Rather than folks on the list providing method after method, it might be helpful for you to give some further information, such as: -- Just approximately, how much data are

Re: [sqlite] SQLite Import Tool

2008-11-12 Thread Baskaran Selvaraj
Thanks. SQLite ODBC driver takes hours for data transfer and most of the time it is not success. > Date: Wed, 12 Nov 2008 12:56:19 -0200> From: [EMAIL PROTECTED]> To: > sqlite-users@sqlite.org> Subject: Re: [sqlite] SQLite Import Tool> > Hi> > > You can

Re: [sqlite] SQLite Import Tool

2008-11-12 Thread Baskaran Selvaraj
Thanks Tom. I tried using DTS but the import process is taking hours and most of the time it fails at the end with timeout. > Date: Wed, 12 Nov 2008 09:58:36 -0500> From: [EMAIL PROTECTED]> To: > sqlite-users@sqlite.org> Subject: Re: [sqlite] SQLite Import Tool> > You

Re: [sqlite] SQLite Import Tool

2008-11-12 Thread Thomas Briggs
You can probably do it with the two systems' command line tools (generate a text file with one and read it with the other). DTS/SSIS will probably do the trick for you too. In short: don't over-complicate things. :) -T On Wed, Nov 12, 2008 at 9:45 AM, Baskaran Selvaraj <[EMAIL PROTECTE

Re: [sqlite] SQLite Import Tool

2008-11-12 Thread Virgilio Fornazin
Hi You can use SQLite ODBC Driver and SQL Management Studio Data Transfer Wizard to perform this action. On Wed, Nov 12, 2008 at 12:45 PM, 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