sql2gdb moves first the schema, then the data (unless you specify
otherwise).

If data does not appear, then something broke. I remember one of the
releases failed to report errors (a thread synch problem), so maybe you
do not have the very latest version?

On Monday I will be including some code changes I was submitted to set
default values instead of NULLs. I'll create a new binary, post it to
http://www.xlprueba.com.ar/ib/ and post a message to this group.

If all goes OK with the new wizard, let me know and I'll send the new
version to the usual sites.

Marcelo Lopez Ruiz

Helen Borrie wrote:

>At 10:53 AM 27-01-02 +0000, you wrote:
>
>>Hi guys,
>>
>>I am trying to convert MS Access and MS SQL Databases into Firebird
>>format. Both tools, SQL2GBD and IBPump, fail. I get the right DB
>>structure (tables, etc.) , but no records are transported. No data
>>appear. What is my problem?
>>
>
>Everything in Firebird happens inside transactions which have to be started and stopped by the client application. Possibly these tools start the transaction and then leave it to the user to commit or rollback (cancel) the transaction...do you see a Commit button (or a button with a big red checkmark) ?
>
>Perhaps those tools are only intended to port the database structure and not pump data?
>
>Why not contact the authors of those tools directly?
>
>..or try another tool...
>
>http://www.ibphoenix.com/ibp_contrib_download.html#MIG
>
>regards,
>Helen
>
>All for Open and Open for All
>Firebird Open SQL Database · http://firebirdsql.org
>