If I had to guess I'd say that the performance problems are transaction related. Switching to text file export/import will give you an opportunity to solve that problem.
-T On Wed, Nov 12, 2008 at 11:29 AM, Baskaran Selvaraj <[EMAIL PROTECTED]> wrote: > > 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 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 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 > _________________________________________________________________ > Color coding for safety: Windows Live Hotmail alerts you to suspicious email. > http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_safety_112008 > _______________________________________________ > 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
