I want to dump an entire Elevate database with its table structure and data into SQL. Is there a tool to do this?

<I want to dump an entire Elevate database with its table structure and data into SQL. Is there a tool to do this?>

The easiest way would be to run EDBMgr and right click on the database and select "Reverse Engineer Database..." to create an SQL Script. You can then output the results to an .SQL file or to a text window.

Barry

Barry wrote:

<I want to dump an entire Elevate database with its table structure and data into SQL. Is there a tool to do this?>
==============
The easiest way would be to run EDBMgr and right click on the database and select "Reverse Engineer Database..." to create an SQL Script. You can then output the results to an .SQL file or to a text window.
==============

Thanks, that's a great start. It doesn't get me the data, but I think I can write a script that exports each table in turn. Any other ideas?

jwtm


In EDBmanager once you've selected the reverse engineer option go to the Output page and check IncludeRows

Roy Lambert [Team Elevate]

jwtm

Note that with larger DBs the size of the resulting script can actually push the capacity of your machine. i.e. All Blob fields will be output into the SQL ... so the text file can end up massive.

If you have a DB with lots of BLOBs I would suggest exporting these first, creating a DB structure without them & converting this to SQL.