This blog will give you the necessary steps to migrate your MySQL BMF repository to another database of your choice. The following databases are supported by BMF: Oracle, SQL Server, MySQL and Sybase. We will be using the Data Migration Wizard that is provided to us by BMF.

The first step is to decide which database platform you would like to do the migration for. Once that is decided, we can begin.

Go to Start | All Programs | Quest Software | Benchmark Factory | Repository | Data Migration Wizard

Click Next. On this next screen you will select the source of the repository. Most people will choose the BMF ODBC Connection since they are migrating from the default location.

Click Next. On the next screen, you will choose the database platform you would like to migrate the repository over to. However in order to select a database, you must create an ODBC connection to that database. If one does not already exist, click on the ODBC Administrator button. Once you select the ODBC connection, put in the necessary username/password to connect to the database. Beware that the BMF objects will be created into this account. If you prefer an independent BMF schema, then please create a new user ahead of time.

Once you have completed the above information and have clicked Next, you will come to a confirmation screen. This will indicate that everything has been setup correctly, and you are now ready to migrate the data.

Click Finish and the wizard will start the migration of your data.

After everything is completed, you can go into the target database to verify that the objects have been created successfully. They will be prefixed with ‘BF’.