Re: Moving DB from MS Access to Informix

Mark Meytin wrote: > > Hello! > > I'm desperately looking for a way to move an Access database to > Informix. Can anybody lend a clue on how to do this? I'm able to > create delimited text file from Access, but how do I pass all > the tables and fields info to Informix, and what Informix utility > do I use to import? I can't seem to figure out a way to create > a plain text DDL file in Access... Any help is much appreciated! > Thanks in advance, > > -M-Try a tool like S-Designor. I believe it will let you import an ODBC source like MS Access and then export Informix DDL. Most tools like System Architect, S-Designor and ERWIN have similar capabilities and would allow you to store a model of the database and print an ERD. I think you can get an eval copy of S-Designor from Powersoft? Frank Dickinson frdi@daleen.com