Re: Import structures from Foxpro?

Freedland, Marat - BALTO wrote: > > Hello, > > I have a large number of data files that need to be ported to Informix from > > FoxPro and Access. Is there a way to import the file structures ( not the > > data itself) into Informix? Otherwise I am looking at the prospect of > manually entering the data dictionary for all those legacy databases. > > I searched through the indexes of Informix manuals and didn't find > anything. I can't believe such a basic tool is would not be included. > > Any advise is greatly appreciated. > Marat Freedland. > > Direct EMail: MFreedland@Pipermar.com If you can generate an SQL file (or if you already have one as documentation) with all the CREATE TABLE and CREATE INDEX statements in it you can run that from isql or dbaccess and it will do the job for you. Informix has a tool, dbschema, which will generate such an SQL file from an existing Informix database. In your case, however, you need one to generate a schema from you legacy database. I don't know whether Foxpro or Access have such a tool themselves but, as you say, "I can't believe such a basic tool is would not be included" Ian