Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #3409
| Path | csiph.com!usenet.pasdenom.info!news.albasani.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail |
|---|---|
| From | "Er!k \\/!$$Er" <nospam@nospam.url> |
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Copy complete dbf to sql |
| Date | Fri, 4 May 2012 13:42:49 +0200 |
| Lines | 39 |
| Message-ID | <a0htlqFsgeU1@mid.individual.net> (permalink) |
| References | <jo04v3$kuo$1@dont-email.me> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; format=flowed; charset="iso-8859-1"; reply-type=original |
| Content-Transfer-Encoding | 7bit |
| X-Trace | individual.net SeaEwomTXj8ThpCwvu/qww7Y5LiapDYCnoOsYinNgE3ES1HhpVVO24gY4gC2l0me4n |
| Cancel-Lock | sha1:erHNfl+S/Gv8G6LeYbVYVKev9SU= |
| In-Reply-To | <jo04v3$kuo$1@dont-email.me> |
| X-Priority | 3 |
| X-MSMail-Priority | Normal |
| Importance | Normal |
| X-Newsreader | Microsoft Windows Live Mail 15.4.3555.308 |
| X-MimeOLE | Produced By Microsoft MimeOLE V15.4.3555.308 |
| Xref | csiph.com comp.lang.clipper.visual-objects:3409 |
Show key headers only | View raw
Hi Dirk,
Write the values to CSV and do a BULK INSERT on the Sql database.
or have a look here:
http://stackoverflow.com/questions/883917/import-dbf-files-into-sql-server
hth
Erik
"Dirk (Belgium)" schreef in bericht news:jo04v3$kuo$1@dont-email.me...
Hi all,
On a daily base, I have to copy all records from dbf to sql.
This is done in a task which runs during the night, but it takes
already 62 minutes (too long).
On this moment, I use the standard VO SQL classes.
First I do a prepare statement INSERT INTO <table> (field1,field2,...)
VALUES (?,?,...)
After this, for each record of the dbf file, I do the
SQLStatement{}:Execute() method with an array of the values.
So, this process takes to long.
My question:
Does someone know how to speed up this process ????
Thanx for any advice,
Dirk (Belgium)
--
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Copy complete dbf to sql "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> - 2012-05-04 08:45 +0000
Re: Copy complete dbf to sql Karl Faller <k.faller_withoutthat_@onlinehome.de> - 2012-05-04 12:35 +0200
Re: Copy complete dbf to sql "Er!k \\/!$$Er" <nospam@nospam.url> - 2012-05-04 13:42 +0200
Re: Copy complete dbf to sql "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> - 2012-05-04 15:17 +0000
csiph-web