We have a rather complex database that we want to reverse engineer into a data modeling tool like Erwin. Since theres is no ODBC in Texis is there an easier way to do this than to do it by hand.
So you're trying to export Texis data to another program.?
Tsql can output comma separated values by using "-f," or tagged values using "-fc". Vortex's <sql> can output xml. Or you can write a small vortex script to output just about any format you need for importing. It may be the various SYS tables you want to export.?
I have been asked to build the ERD's for the tables so that some of it can be ported to another database platform. We are going to leave a majority of the database in Texis but one section that consists of 30 or so tables needs to be mapped in Erwin.
Its not that there's no ODBC, there just isn't ODBC available on the Alpha platform.
One way to map things would be to use cpdb from the Alpha to an NT box and then attach via ODBC to the Texis on the NT version of the DB. Since all you're doing is schema work this should not pose too much trouble and you won't have to copy the huge tables.
