The schema for an ACT database can change when ACT is updated or when a new version of ACT is released. If the schema for an ACT database does not match the current schema, you can migrate the compatibility data to a new database. You can then use the current version of ACT to open the new database.
To create the new database, you must have database-creation permissions on the instance of SQL Server.
Migrating Compatibility Data from an ACT Database
You can migrate compatibility data from an ACT database to a new database by using one of the following methods:
- Run Application Compatibility Manager (ACM),
and then use the ACT Configuration Wizard to open the database. The
wizard guides you through migrating the compatibility data to a new
- Run the MigrateDB.sql file. The following
table shows the location of the MigrateDB.sql file.
Operating system Path
Windows Server® 2012
Windows Server® 2008 R2
Windows Server 2008 with Service Pack 2 (SP2)
%SYSTEMDRIVE%\ProgramData\Microsoft\Application Compatibility Toolkit\MigrateDB.sql
Windows XP with Service Pack 3 (SP3)
%SYSTEMDRIVE%\Documents and Settings\All Users\Application Data\Microsoft\Application Compatibility Toolkit\MigrateDB.sql
Database Migration from ACT 5.6
When you migrate compatibility data from an ACT 5.6 database to a new database, the following information is excluded from the migration:
- Issues that were reported by ACT 5.6
data-collection packages (DCPs).
- Solutions that correspond to issues reported
by ACT 5.6 DCPs.
- Lists of file names that ACT 5.6 associated
with each application.
You cannot migrate any compatibility data from ACT databases that were created on a version of ACT before ACT 5.6.