Re: Generating SQL from database

Two things we have used in the past.

1. In enterprise manage, select create like and object, then click on show SQL, you can then copy and paste that statement. Good, but very lengthy.
2. Export the entire database with ROWS=N. This will get the structure which you can import into your new database. You can also issue a strings on the export file to see the contents and then edit them manually, although this will take some time, since each statement will be one line. Watch for chopped off lines.