How to use BTR2SQL for a multi-company application migration
Multi-directory layouts, where general information is stored in a top directory and regional specific information is stored in lower directories, are common in Btrieve databases.
However, when planning a migration from Btrieve to a SQL backend you must remember that on the SQL side, different tables with the same names collide if stored in the same database.
To avoid a collision, you have a few options:
- Migrate to a separate server or database
- Migrate to a separate schema
- Migrate using a different table prefix or postfix
Get the guide for the step-by-step procedures you need in order use the BTR2SQL GUI for performing a multi-company migration: