DbMigrator (Results Database Tool)

Db Migrator is an application that creates a new Results database and upgrades an existing Results database. This application is included with the CM4D Server installation and should only be run by DBA users or someone with a clear knowledge of CM4D and its databases.

The version of CM4D and the version of the DbMigrator must match. Do not run a version of the DbMigrator that was not delivered with the version of CM4D you have installed.

The Results Database connection information must be set in SiteManager before you can run DbMigrator. The Test Connection will fail if this is the first time the DbMigrator is run (as the database does not yet exist). This is acceptable as long as you are sure that the information entered is correct.

Some organizations may have a dedicated Database Administrator outside of CM4D users that creates and maintains all databases, or may need to run DbMigrator separately from CM4D for another reason. In such cases, the information here can be provided to a DBA or other qualified user that will create the CM4D Results Database. The DbMigrator tool is included with the CM4D Server installation. After installation, the DbMigrator folder can be copied directly from the CM4D installation folder and delivered separately to your DBA.

Set the configuration file as needed and then run the DbMigrator.

DbMigrator Configuration File

The DbMigrator Config file options should be set up with your Results database connection information before running the DbMigrator application. If the settings are changed afterwards, you must re-run DbMigrator to apply any new settings.

Default Path: .\Program Files\Applied Tech Systems\CM4D\Db Migrator\ATS.CM4D.Conestoga.DbMigrator.exe.config

Set the following:

fiscalStartMonth - Set the month of the start of your fiscal year. Enter a value of 1-12. By default, this is set to "1" for January.

fiscalStartDay - Set the day of the month as the start of your fiscal year. Enter a value of 1-31. By default, this is set to "1" for the first day of the month. Make sure to use a day that is valid for the set month.

Configuration Example

</appSettings>

Run the DbMigrator

See the topic, Run DbMigrator.