Generating Database Script

rameshkumar · #1 (**permalink**) 06-17-04, 03:38

Dear friends,

Is there any way to generate the SQL Script of the entire Sybase iAnywhere database? Will appreciate if you can help me out in this regard.

Thanks in advance

Ramesh

osy45 · #2 (**permalink**) 06-17-04, 04:52

if you have such tools like powerdesigner you can reverse engineer the database and get the scripts and even the model from the tool
other ERM Tools as well support rev eng

maybe Ed Barlows site offers some scripts as well although they focus primaryly on ASE

svelasco · #3 (**permalink**) 07-13-04, 16:43

If you have installed SQL Central and the plugin for Anywhere (ASA), you can use the utility "Unload database". You can genereate the sql script and/or unload all the data from the tables.
Bye

Sebastian