Is there a tool like DBScriptor that works with MySQL?

[dchristensen]

Wondering if there is a tool like DBScriptor that would work with MySQL? DBScriptor won't work, at least as I've seen it work with other databases.

Thanks.

 

[danielhozac]

And what exactly is DBScriptor? I've never heard of it. //Daniel

 

[dchristensen]

DBScriptor is a tool that will look at a SQL database via ODBC and generate DDL from the existing database. I've used the tool quite often in situations where I've had to maintain databases after someone else has established them, then split without leaving source or documentation. By generating new DDL from the live database, I know that I have what is in production at the time.

My need tonight is because I need a DDL script to move a MySQL database from a WIndows 2K box to a LINUX box here at home and the source DDL is at my office 40 miles away. Just wanted to get a few more things done before heading to bed.

Any ideas?

 

[sleipnir214]

Why not just use mysqldump (or in your case mysqldump.exe)? It should have installed on your W2K box when you installed MySQL. ______________________________________________________________________
TANSTAAFL!

 

[dchristensen]

Haven't tried that, but will look at it. I later discovered that I can build a "dialect" file for DBScripter that should hit the MySQL syntax.

Thanks!