Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
How to import Firebird 2.5 tables into EDB ? |
Wed, Oct 29 2014 10:55 AM | Permanent Link |
TD Advanced Data Systems, Inc. | 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 |
Wed, Oct 29 2014 12:56 PM | Permanent Link |
Matthew Jones | 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 |
Wed, Oct 29 2014 1:56 PM | Permanent Link |
TD Advanced Data Systems, Inc. | "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 |
Thu, Oct 30 2014 5:55 PM | Permanent Link |
Adam Brett Orixa Systems | 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 |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |