Re: Moving DB from MS Access to Informix

Nigel Hall wrote: > > In article <32222268.5CA2@teir.com>, Mark Meytin <mmeytin@teir.com> wrote: > > > Hello! > > > > I'm desperately looking for a way to move an Access database to > > Informix. <snip> I can't seem to figure out a way to create > > a plain text DDL file in Access... <snip> > > -M- > > <snip> > You need INet/ODBC set up for the Informix database that you want to hold > your tables in. > > <ODBC sets up tables, output files, transfer them and load into informix> > And that should be it. > There may be a better way. Use a reverse engineering tool (StarDesignor by Powersoft or ER/Win <not sure if it reverse engineers Access..>). This will give you a good graphical layout of your DB that you can then get raw DDL for. The note of outputing in a delimited format and loading in would still apply. OTOH, you could use an ODBC connection to the DB and run MS Access queries to copy data between the local and remote versions of the DB. Hope this helps 8) Side note - anybody have experience using ER/Win with Informix 7.x? We're starting to use in here and I was wondering if anyone has run into bugs\\ limitations\\workarounds etc.. /glen glen@earthweb.com