Re: [sqlite] SQLite Import Tool
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 application and source:> > http://www.proghack.net/?p=40> > On Wed, Nov 12, 2008 at 3:20 PM, Baskaran Selvaraj <> [EMAIL PROTECTED]> wrote:> > >> > 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> 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> > _> > Windows Live Hotmail now works up to 70% faster.> >> > http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_faster_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 _ See how Windows® 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
Re: [sqlite] SQLite Import Tool
Here is a link to the application and source: http://www.proghack.net/?p=40 On Wed, Nov 12, 2008 at 3:20 PM, Baskaran Selvaraj < [EMAIL PROTECTED]> wrote: > > 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> 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 > _ > Windows Live Hotmail now works up to 70% faster. > > http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_faster_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
Re: [sqlite] SQLite Import Tool
has any one expressed an interest to help out? it does not seem to be all that difficult, notwithstanding your mention of time-out issues. please let me know a bit ore detail about the db you are exporting, and we can see if it is a project we can do quickly for you. thanks- Keith T the SLK Groups On Wednesday 12 November 2008 11:30:48 Baskaran Selvaraj wrote: > 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 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 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 > > _ > See how Windows® 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
Re: [sqlite] SQLite Import Tool
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> 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 _ Windows Live Hotmail now works up to 70% faster. http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_faster_112008 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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
Re: [sqlite] SQLite Import Tool
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
Re: [sqlite] SQLite Import Tool
> On Nov 12, 2008, at 11:52 AM, Baskaran Selvaraj wrote: > > Thanks Kishore but I am exporting data from SQL Server and importing > into SQLite database. Thanks for the update, but I am not sure how that changes what I suggested. A few lines of Perl (or whatever language you prefer) will automate data going either way. Set a cron task for your script and it will get done on schedule. Perl has competent DBDs for both SQL Server and SQLite. Finally, please reply to the list as there many on the list far more knowledgeable than I in all matters relating to life, the universe and 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. Size of the SQLite Database : 43 MB. > > 2. Number of tables : 45 > > 3. Maximum number of rows in a table is around 75,000 > > > Why don't you just dump the SQLite db and import that into SQL Server? > If you want to automate that, a few lines of Perl will do the job more > quickly than an elongated thread on the mailing list. > > > > > > We initially tried with few tables and it was not always successful but > > after we got to 45 tables, > > we did not use SQLite ODBC driver at all. > > > > Rght now, I am using SQL Maestro Data Wizard. This tool has a feature to > > automate data import using templates > > but since we have exceed the ini file limitation of 64 KB, I have to run it > > using the wizard each time not automation. > > Right now, using the Data Wizard 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,> > 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 you converting regularly.> I.e., how many megabytes , > > > tables, and rows are involved?> > > -- You mention that you are now doing > > > this "manually". Could you> elaborate? Does this mean you're dumping the > > > data to some text format,> then importing into sqlite with, perhaps the > > > sqlite3.exe> command-line-tool? If so, might simply adding a batch script > > > to this> process give you the automation you need? > > -- How long does > > > the manual conversion take to run? > > -- Have you determined which of > > > your tables is giving you the problem?> How far into your conversion are > > > you getting?> > ___> > > > sqlite-users mailing list> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Import Tool
On 11/12/08, Baskaran Selvaraj <[EMAIL PROTECTED]> wrote: > > Hi Donald, > 1. Size of the SQLite Database : 43 MB. > 2. Number of tables : 45 > 3. Maximum number of rows in a table is around 75,000 Why don't you just dump the SQLite db and import that into SQL Server? If you want to automate that, a few lines of Perl will do the job more quickly than an elongated thread on the mailing list. > > We initially tried with few tables and it was not always successful but > after we got to 45 tables, > we did not use SQLite ODBC driver at all. > > Rght now, I am using SQL Maestro Data Wizard. This tool has a feature to > automate data import using templates > but since we have exceed the ini file limitation of 64 KB, I have to run it > using the wizard each time not automation. > Right now, using the Data Wizard 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,> > 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 you converting regularly.> I.e., how many megabytes , tables, and rows > are involved?> > > -- You mention that you are now doing this "manually". > Could you> elaborate? Does this mean you're dumping the data to some text > format,> then importing into sqlite with, perhaps the sqlite3.exe> > command-line-tool? If so, might simply adding a batch script to this> process > give you the automation you need? > > -- How long does the manual conversion > take to run? > > -- Have you determined which of your tables is giving you > the problem?> How far into your conversion are you getting?> > > ___> sqlite-users mailing list> > sqlite-users@sqlite.org> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _ > 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 > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Import Tool
Hi Donald, 1. Size of the SQLite Database : 43 MB. 2. Number of tables : 45 3. Maximum number of rows in a table is around 75,000 We initially tried with few tables and it was not always successful but after we got to 45 tables, we did not use SQLite ODBC driver at all. Rght now, I am using SQL Maestro Data Wizard. This tool has a feature to automate data import using templates but since we have exceed the ini file limitation of 64 KB, I have to run it using the wizard each time not automation. Right now, using the Data Wizard 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,> > 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 you converting regularly.> I.e., how many megabytes , tables, and rows > are involved?> > > -- You mention that you are now doing this "manually". > Could you> elaborate? Does this mean you're dumping the data to some text > format,> then importing into sqlite with, perhaps the sqlite3.exe> > command-line-tool? If so, might simply adding a batch script to this> process > give you the automation you need? > > -- How long does the manual conversion > take to run? > > -- Have you determined which of your tables is giving you > the problem?> How far into your conversion are you getting?> > > ___> sqlite-users mailing list> > sqlite-users@sqlite.org> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _ See how Windows® 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
Re: [sqlite] SQLite Import Tool
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 you converting regularly. I.e., how many megabytes , tables, and rows are involved? -- You mention that you are now doing this "manually". Could you elaborate? Does this mean you're dumping the data to some text format, then importing into sqlite with, perhaps the sqlite3.exe command-line-tool? If so, might simply adding a batch script to this process give you the automation you need? -- How long does the manual conversion take to run? -- Have you determined which of your tables is giving you the problem? How far into your conversion are you getting? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Import Tool
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 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 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 _ See how Windows® 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
Re: [sqlite] SQLite Import Tool
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] SQLite Import Tool
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® 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
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
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]> 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
