ACT Database Migration
Updated: May 31, 2012
Applies To: Windows 8, Windows 8.1
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.
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 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
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.