Re: How to export an Informix db to MS SQL Server 2000?

Doug Baroter wrote: > Folks, > > As it turns out, it's actually something called UniData RDMBS, version > 5.2. > Since Informix has bought the company that owned UniData, the package > is shipped by Informix, so, the client thought it's Informix database. > > Now, the first thing I'd like to do is to get to know the data schema, > any way to generate an ERD type of thing with it? > > Thanks. The home page for IBM's "UniData" and "UniVerse" databases is http://ibm.com/software/data/u2 and you'll find links there to answer your questions. "UniData" and "UniVerse" are 2 different products, but they're similar, and IBM refers to them collectively as the "u2" products. IBM has a single group, based in Denver, doing engineering and marketing for both products. They're great folks and they can also provide you with IBM consultants or refer you to independent consultants in your area. The reason why you might need a consultant is that most UniData applications don't have a schema, and the data dictionaries are typically full of holes and mistakes, in which case you have to build a schema by reverse engineering the UniBasic application, which is a non-trivial task. If the application came from one of IBM's VARs, then IBM's consultants probably won't touch it, because IBM doesn't want to disturb their VARs. Most Unidata-based applications are from independent software vendors, also known as VARs, and commonly the UniBasic source code is only at the VAR's office, not at the end-user's office, in which case the only good way to build a good schema is to go back to the original VAR and pay them to do it.