By Use Case
This article will show you how to migrate your CurrentWare Firebird database to SQL database
Prerequisite: you must have a SQL server installed on your computer or on your network. If you don’t have SQL Server, learn how to Install SQL Express (free edition) on your computer.
Note: this is a unidirectional database migration. Once you migrate your data to the new SQL database, there is no way to migrate back to Firebird.
If the initial database migration failed or closed unexpectedly, you can launch the migration tool from the following location:
C:\Program Files (x86)\CurrentWare\cwServer\CWDBMigration.exe
Once the migration begins, the tool will create a new database on your SQL database and copy the data from your existing Firebird database. The data on the Firebird database will not be deleted. You can use it as a backup. Keep in mind that no new data will be added to the Firebird database. All the new data will be written on your migrated SQL database.
Data migration will take some time with large databases. Do not close the tool while the migration is happening. If you do, the SQL database might get corrupted and you’ll have to create a new database and perform the migration again.