In DBISAM you could export tables and data into a "DBISAM compatible" script with insert statements. Can you do this with ElevateDB? I am most interested in getting the "Insert into" commands into a script.

Thanks,

Michael

Just to clarify, I want the script to be a ElevateDB compatible script.

Michael wrote:

Can you do this with ElevateDB?

On 8/7/2014 5:09 PM, Michael wrote:
> In DBISAM you could export tables and data into a "DBISAM compatible" script with insert statements. Can you do this with ElevateDB? I am most interested in getting the "Insert into" commands into a script.
>

Check out the reverse Engineer function (right click on database). Make
sure you select include rows option on output page to get the data as well.

Raul

Michael


If you only want one or two tables then in EDBManager:

1. open session
2. open database
3. create new sql
4. back on the left hand side select tables
5. drag'n'drop a table onto the blank sql window

EDBManager will then insert the code for creating the table and optionally the data (rows)

What it will not do is insert any code for creating indices. Can't remember if it does constraints other than the primary key.

Roy Lambert

Micheal,

You should also review EDB's EXPORT TABLE / IMPORT TABLE SQL statements. These offer a different route for data transfer in / out of tables which is very useful and goes far beyond the capabilities in DBISAM.