Re: How to port table designs rom MS-ACCESS to Informix ?
Posted in 1996
> vijay@newsserver.uconn.edu (Stochastic Dreams) writes: > 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 The easiest way would probably be to buy some database design tool that support reverse engeneering from MS Access and can generate Informix code. Otherwise it shouldn't be too hard to write an MS Access (or VB) program that reads the tables and fields collections and writes create table statements to a file. Nils.Myklebust@ccmail.telemax.no NM Data AS, Postbox 9090, Gronland, 0133 Oslo, Norway My opinions are those of my company