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 StarDesignor from Powersoft (@ $330) will support both functions listed in number 1 above. **----------------------------------------------** || Darrell S. Thacher dthacher@gte.net || || IntegriSoft, Inc. 817-430-8410 (voice) || || Flower Mound, TX 817-430-4495 (fax) || **----------------------------------------------**