I am new to EDB and have played around with ElevateDB Manager trying to find a way to import the table structure and data from my Firebird 2.5 database.  Surely their must be a way to do this.  All help is greatly appreciated.

TD

TD wrote:

> ElevateDB Manager trying to find a way to import the table structure
> and data from my Firebird 2.5 database

If you right click on your session, there is an item "Create database
migrators". Once that is done, you can right click on a database to get
"Migrate database". That then allows you to connect to a number of
databases, including ADO. I forget the details because I only did a
DBISAM database once, but IIRC you can save the SQL if it fails to
work, then edit it and run it again with corrections. I expect the
manual has all the detail you need now you have the pointer to the term
used.

--

Matthew Jones

"Matthew Jones" wrote:
If you right click on your session, there is an item "Create database
migrators". Once that is done, you can right click on a database to get
"Migrate database". That then allows you to connect to a number of
databases, including ADO. I forget the details because I only did a
DBISAM database once, but IIRC you can save the SQL if it fails to
work, then edit it and run it again with corrections. I expect the
manual has all the detail you need now you have the pointer to the term
used.

Thanks Matthew,
TD

TD

Another thing to consider is to go via a neutral flat-file format like CSV if it is useful to do reformatting of the data and you don't mind fiddling around with recreating DB Functions and procedures.

EDB has good commands "IMPORT TABLE" which will take a CSV file as source and work even on large files (I have imported up to 160,000 rows, which I think is large).

I am sure you can generate CSV from Firebird. This gives you a chance to clean up the data a bit during the import process.

I think it should be possible to recreate Functions and Procedures too. EDB's SQL syntax is pretty standard, so a lot of the code for these could be cut & pasted from your Firebird DB instance and re-run to add any function to the EDB db.

Adam