Creating and updating databases for CM4D can be a challenge, so we have provided four tools to make this database maintenance easier. Instead of locating the scripts and running each script individually on each database (and in the right order), you can simply run each tool and select an action.
The CM4D Site, CM4D and Results databases can be created manually by running scripts in SSMS or using the utilities provided in the CM4D install folder.
To ensure you have sufficient system privileges to run the database utilities, it is recommended to execute the tool using 'Run as administrator'.
The Site Database Utility is a simple command prompt tool that executes all the scripts necessary to create a new CM4D Site database or upgrade a v24 or v25 Site database to the latest site db schema.Run all necessary scripts on an empty Site database or upgrade a Site to either v24 or v25. Connection information is obtained from the CM4D.4ds file (via DbConnect).
See the topic Site Database Utility for details.
The Datasource Database Utility is a simple command prompt tool that executes all the scripts necessary to create a new CM4D Datasource database or upgrade a v24 or v25 CM4D Datasource to the latest database schema.
See the topic Datasource Database Utility for details.
Results Database Utility is simple tool that create an entirely new Results database, create the tables for an empty database or upgrade an existing Results database from a previous version. In cases of upgrading, the tool automatically detects the existing database tables and adds or changes tables as needed. This application is included with the CM4D Server installation (.\CM4D\Database Utilities\) and should only be run by DBA users or someone with a clear knowledge of CM4D and its databases.
See the topic Results Database Utility for details.
Database identifiers for Routines, Features and Samples in a CM4D Database must be unique within the Site database. When a CM4D database is copied (i.e., backup/restore) and added as a new Managed Datasource to a different Site database, problems may occur if there are GUID conflicts with other CM4D databases managed by that Site database. The GUID Replacer is a utility that reassigns Routine, Feature and Sample GUIDs in a CM4D Database. The GUIDs can replaced all at once or for only Routines/Features/Samples individually, and each option can be done in batches. This tool can be used on any CM4D database with errors related to GUID conflicts.
See the topic GUID Replacer for details.
Can we improve this topic?