Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #3409

Re: Copy complete dbf to sql

From "Er!k \\/!$$Er" <nospam@nospam.url>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Copy complete dbf to sql
Date 2012-05-04 13:42 +0200
Message-ID <a0htlqFsgeU1@mid.individual.net> (permalink)
References <jo04v3$kuo$1@dont-email.me>

Show all headers | 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


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