Import structures from Foxpro? 
Author Message
 Import structures from Foxpro?

Ian Goddard wrote

Quote:


>>  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      .

......................................................................



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Import structures from Foxpro?

2. Importing DTS Structured Storage File

3. DTS Import Of Structured Report File

4. Help: importing flat data into relational structure

5. Help: importing flat data into relational structure

6. [DTS] - Importing Tables with diff. Structures

7. [DTS] - Importing Tables with diff. Structures

8. - Importing Tables with diff. Structures [URGENT (very)]

9. SQL7 import changed table structures

10. Importing Data and Structure from MS Access

11. Importing data (different structures) from a text file

12. import loosely structured text files


 
Powered by phpBB® Forum Software