Re: Import structures from Foxpro?
Ian Goddard wrote
>
>Freedland, Marat - BALTO wrote:
>>
>> 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.
>>
>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"
One option would be the StarDesignor of Powersoft. You can reengineer and
produce SQL script files. As my version (1.0.0.2) showed me, drivers for
FoxPro and MS-ACCESS are included. After closing the reengineering process,
any StarDesignor supported target DBMS system can be choosed.
Related to INFORMIX, target models are: up from version 5 to 7.1.
The target model can be load as pure SQL (script file) or via ODBC to the
INFORMIX database.
--
Chris Drauch
......................................................................
. c/o DRAUCH Ges.m.b.H. Tel. 43/ 3135/46387-0 .
. Gewerbestrasse 5 Fax 43/ 3135/4638728 .
. A-8071 Hausmannstaetten EMail cdr@xteam.co.at .
......................................................................