Notice 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.
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.
Notice
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.
Tip
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.
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.
<appSettings>
<add key="fiscalStartMonth" value="1" />
<add key="fiscalStartDay" value="1" />
</appSettings>
See the topic, Connect to the Results Database.
See the topic, Configure DbMigrator.
See the topic, Run DbMigrator.