Problems importing SQL data

[David Nock]

On 11/3/04 10:22 AM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> On 3/10/04 11:12 PM, "David Nock" <davidn at accessitsoftware.com> wrote:
> 
>> I'm trying to import a file of data that has been exported in SQL format.
>> 
>> So far this is the result:
>> 
>> Executing SQL statements 1 by 1 works for a while then slow to a crawl
>> i.e. 1 record/sec
>> This eventually aborts after 19000 lines with a ', was expected' error. I
>> copied out the offending record plus a few either side into a separate file
>> and this file imports fine. This is also frustrating because it takes a few
>> hours to get here.
>> 
>> Tried adding a flush every few records, but this causes an Error 351 after
>> only a few records.
>> 
>> Tried importing via LoadDump (SQL), which reports that all imported fine
>> after a very short time, but nothing has actually been imported.
>> 
>> Any have any thoughts on what to try next.
>> 
>> This is on Windows, a60, C++.
> 
> Hi David,
> 
> 1) SQL LOAD DUMP not finished.
>   you only can self parse each next command (up to ;)
>   and send command by command.
> 
> viSQL utility can do this.
> but Hmm, you say this not works for you.
> 
> 2) if you have task import data from other DBMS, please look on
> Valentina_ODBC utility. You can import directly from DBMS via ODBC driver.
> Valentina Studio also can do this now.
> 
> 
> 3) I wonder you get 351 error on small db.
>   what cache size of Valentina you use?
>   use 8-10MB cache.
> 

Hi Ruslan,

1) Have grabbed a copy of viSQL but doesn't seem to support server, only
local db.

2) No ODBC driver available. :-( Guess I could always dump the SQL file into
MySql and then out through MyODBC. ;-)

3) Is this the value passed to ValentinaInit() or the value in the
Server.ini file. They are 3Mb and 40Mb respectively.

Cheers
Dave

**********************
David Nock
Senior Developer
Access-It Software Ltd
**********************

This email and any attachments are confidential and intended exclusively for
the person to whom the email is addressed. If you are not the intended
recipient, do not read, copy, disclose or use the contents in any way.
Please notify us immediately by return email and destroy the email and
attachments. Access-It Software Ltd does not accept any liability for any
changes made to this email or attachments after sending by Access-It
Software Ltd. You must scan this email and attachments for viruses. The
opinions expressed are not necessarily those of Access-It Software Ltd.

Access-It Software Ltd accepts no liability for any loss, damage or
consequence, whether caused by our own negligence or not, resulting directly
or indirectly from the use of this email and attachments.