In general you are heading the right way - you can migrate your database by creating scripts that will cover all the differences in your schema. There are some possible problems that you should have in mind, including, but not limited to:
- Currently Telerik OpenAccess ORM supports only version 2.0 and 2.1 of Firebird.
- There might be specifics in the Firebird databases when migrating from version 1 to version 2, which we are not aware of - better search the documentation of Firebird for that matter.
- Telerik OpenAccess ORM can detect schema differences in the Update Database from Model wizard
. So if you have a Domain Model, it can be applied on the new database. However, the script that is generated never deletes columns or tables - it only adds new ones or updates the current schema objects. That means you will have to add the delete statements manually.
- You should also think whether you need data migration and how you can achieve it. We are not providing any tools for that.
You can execute the scripts created by OpenAccess ORM directly from the Update Database from Model wizard, once you have connected to the target Firebird database. Unfortunately we don't have any examples for using Firebird client applications instead of the wizard.
Do not hesitate to let us know if you need further clarifications.
All the best,
the Telerik team
Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward!
We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>