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 database.

  • Run the MigrateDB.sql file. The following table shows the location of the MigrateDB.sql file.

    Operating system Path

    Windows® 8

    Windows® 7

    Windows Vista®

    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.