Abstract
When the BDE database was migrated to Firebird in a first step, or a company decides to move from Firebird to MS SQL at a later point, this guide can be used
Preparation
- Copy the existing database configuration file NCPro_DB.INI file in the application directory to NCPro_DB_Source.INI
- Start an up to date version of ProfDiaToolbox
- Go to Database Configuration
- Click on Load From INI
- Adjust the elements at (1) and (2) according to your new MS SQL Server
When the modifications are entered, click on Setup Database then Test Connection
When everything was setup correct, the success message should pop up
otherwise an error message showing the actual problem will be shown.
When the connection to the new Database can be established continue with the next step
Data Migration Standard Procedure
- open the Migrate/Merge SQL→SQL tab
- Copy the absolute path to your “old” database configuration in the Source Database Config File field
- Copy the absolute path to your updated database configuration in the Target Database Config File field
- When the target database is empty (default), click on the migrate button to start the database migration
- Wait for the process to be finished
- When everything is done, the ProfDia Toolbox can be closed and the new database is ready for use
Data Migration Special Cases
The first migration to the new database has to be done like described above in Data Migration Standard Procedure.
Note
The migration script has to be run from the PC having the access rights to the original source database
As soon as the database already contains some projects, the Merge Settings have to be applied.
- Check the Use Merge Mode option and select the merge type:
| Type | Description |
|---|---|
| Skip Existing Projects | Only projects that are not already stored in the new database will be added |
| Overwrite Existing Projects | New projects will be added and existing projects will be overwritten |
| Add with Suffix | All projects from the source database will be added with the Suffix value (e.g. original project: 12345, migrated project: 12345_MachineID ) |