Subject Re: [IB-Conversions] Re: Migrating database from MS SQL or PostgreSQL
Author Marcelo Lopez Ruiz
----- Original Message -----
From: "Helen Borrie" <helebor@...>
> >Hm, excuse me for bugging you, but do you
> >know an automated way of converting MS Access mdb's
> >into gdbs ? Or a nice BDE GUI for doing that ?
>
> Nice GUI, no. Horrible GUI, yes, somewhere, I'll see if I can find it and
> I'll zip it up and put it into the Files area of this list. You'd need to
> work with the source - to alter the table properties on the fly. (I said
> it was ugly!) If I had more time (which I don't, believe me!) I'd fix it
> up so it would loop serenely through a whole database automatically.
It's
> doable, pretty easily. Perhaps someone would like to pick up the bare
> bones and make a proper conversion app out of it...

I have an Access->InterBase wizard, but it's *extremely* simplistic, and
I've used it for simple convertions. It's probably full of bugs, but it got
the job done for me. The GUI's nice enough, and it's based on ADO, with the
idea of using it to pump data from other databases.

I've zipped the binary and source files, and posted them on the
IB-Conversion's File section. I'll still be on the lookout for Helen's code,
though :-) I'd be really thankful for any improvements to my own code, too.

Marcelo Lopez Ruiz

P.S.: Source specifics: Written in Delphi 5, using InterBase Express
components and ADO and ADOX librarires (install the latest MDAC if you
haven't got up-to-date libraries).