<plug>
Hi,
GUI3000 will do what you want. It will produce the SQL code to produce a
database in SQL Server and MySql syntax, with Oracle to follow shortly.
GUI3000 will also migrate your data to 'flat' files ready to import into the
database using BCP or Sql Loader.
As a bonus, it will also migrate Image databases to MS Access.
Fields are configurable, so you can translate date fields 'on the fly'.

For more details, see www.gui-innovations.com which has some screen shots,
or www.gui3000.com or www.gainsborough.com  for a demo version.

HTH

Pete

</plug>

"Tom Emerson" <[log in to unmask]> wrote in message
news:a640r001sva@enews4.newsguy.com...
> ..a program to translate a standard IMAGE Schema (which we all know and
> love) into that obscure set of cryptic incantations needed to build a
> functionally similar database using nothing more than SQL "create table"
> commands?
>
> Or is this going to be a case of "my personal itch to scratch", and thus
yet
> another "open source" program will be born?  [and/or, "who would like to
> help with such a project?"]
>
> I'd much rather sit down and think about the structure and contents of a
> database rather than (essentially) run DBSCHEMA with :FILE DBSTEXT=$STDIN
> and have to worry about how I spelled item names from one table-instance
to
> the next... ;}
>
> Tom
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *