Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there a way to directly convert an access database to fdb(firebird) format using microsoft access? If not what's the best way?

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

As long as you can establish an ODBC connection to the remote database... you can export the data to the other database server. Sometimes you must do some of the conversion manually... as each database flavor implements data-types differently. (you can usually get around this by creating a similar database structure on the other side... then export data to the existing tables.)

share|improve this answer
add comment

In order to do this, you would need to re-create the database in Firebird.

Check the MS Access metadata, extract SQL statement to create the tables and convert these to Firebird format, create a new Firebird database and re-create the metadata.

Next, you can transfer the data.

Shameless-plug-mode: this all can be done using Database Workbench ( www.upscene.com ) -- it can convert the metadata for you, so you don't have to work out differences between datatypes and SQL syntax (via the Schema Migration tool) and it includes a DataPump to transfer data.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.