Re: [sqlite] Convert / Import

[Bogusław Brandys]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Griggs, Donald wrote:
> -Original Message-
> From: administrator [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, August 16, 2005 5:01 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Convert / Import
> 
> 
> Does anybody know a good/quick way to convert  from V.Fox 8 .dbf to sqlite
> format ? I tried to export to .csv from Visual Fox , then to import into .db
> using SQLite Database Browser but it just takes to much time (running for
> 2h50m now and still going, a ~ 2.000.000. rows each with 32 fields ) and
> hassle. Any quick way to do this ?
> 
> Thank you.
> 
> Dumitru Florin.

Tray SQLiteExplorer function to import from ADO source.

Regards
Boguslaw Brandys
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.0 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDBvbZtuGICzHOh+YRAtHbAJ966TneTsI84Dn+IuzLcSEfOtcwYgCfaz9s
Y2nQ8YJo+1JqNvcN4lW2wcE=
=90l6
-END PGP SIGNATURE-

RE: [sqlite] Convert / Import

[Griggs, Donald]

-Original Message-
From: administrator [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 16, 2005 5:01 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Convert / Import


Does anybody know a good/quick way to convert  from V.Fox 8 .dbf to sqlite
format ? I tried to export to .csv from Visual Fox , then to import into .db
using SQLite Database Browser but it just takes to much time (running for
2h50m now and still going, a ~ 2.000.000. rows each with 32 fields ) and
hassle. Any quick way to do this ?

Thank you.

Dumitru Florin.
=

If you end up continuing to use .CSV and importing, you may want to create
your indices after the import, and turn the synchronous parameter OFF (until
after the conversion).  These should reduce the total conversion time.  




Donald Griggs

Opinions are not necessarily those of Misys Healthcare Systems nor its board
of directors.

Re: [sqlite] Convert / Import

[administrator]

Thank you ! That did it in 17 minutes.

- Original Message - 
From: "Sergey Startsev" <[EMAIL PROTECTED]>
To: "administrator" <sqlite-users@sqlite.org>
Sent: Tuesday, August 16, 2005 12:08 PM
Subject: Re: [sqlite] Convert / Import


> Hello administrator,
>
> Tuesday, August 16, 2005, 5:01:23 PM, you wrote:
>
> a> Does anybody know a good/quick way to convert  from V.Fox 8 .dbf to
sqlite
> a> format ? I tried to export to .csv from Visual Fox , then to import
into .db
> a> using SQLite Database Browser but it just takes to much time (running
for
> a> 2h50m now and still going, a ~ 2.000.000. rows each with 32 fields )
and
> a> hassle. Any quick way to do this ?
>
> You can try SQLite Analyzer
> http://www.kraslabs.com/sqlite_analyzer.html
>
>
> -- 
> Best regards
>
>  Sergey Startsev
>
>

Re: [sqlite] Convert / Import

[Sergey Startsev]

Hello administrator,

Tuesday, August 16, 2005, 5:01:23 PM, you wrote:

a> Does anybody know a good/quick way to convert  from V.Fox 8 .dbf to sqlite
a> format ? I tried to export to .csv from Visual Fox , then to import into .db
a> using SQLite Database Browser but it just takes to much time (running for
a> 2h50m now and still going, a ~ 2.000.000. rows each with 32 fields ) and
a> hassle. Any quick way to do this ?

You can try SQLite Analyzer
http://www.kraslabs.com/sqlite_analyzer.html


-- 
Best regards

 Sergey Startsev