Re: How to port table designs rom MS-ACCESS to Informix ?

At 07:15 pm 24/04/96 GMT, you wrote: >Hi guys, >I developed a database application in MS-Access. Our clients >want it to be ported to Informix. My question is this: >Is there a simple way to port the table designs from my MS_ACCESS >application to Informix, withut manually enetring all those >designs using DB-Access of Informix ? >I am fairly new to the database field. This might be a stupid >question for you wizkids. >I appreciate your help. >vijay@sol.uconn.edu > I can think of 2 ways: 1) Use a case tool that supports both reverse engineering of Access DB's and sql script generation for Informix DB's. 2) Access 2.0 has a database documentor add-in facility. This will let you save the table definitions in a single new db table. You can then write a report that outputs the data from this table as an SQL script to create the informix DB. Dominic Pratt