Migrating the EnterWorks Data Model

In order to migrate the EnterWorks Data Model from one EnterWorks server to another, for example, from Development to QA or QA to Production, the following procedure must be performed.

The types of migrations and when they need to be performed are described in the table below:

Migration	When Performed
EnterWorks Data Model Migration	Code set definition changes Addition, modification (e.g., character length, data type, etc.) or removal of attributes to any profiles Hierarchy or Taxonomy changes (e.g., addition of new nodes) Change to attribute order, group, or tab assignments.
Repository Migration	Addition of attributes that have been added to the snapshot table. Change of default values. Change of assignment of Pop-Up controls and pages.
Update Snapshot Table Views	Automatic on an as-needed basis.
Restart of EnterWorks Services	After any of the above steps are performed.

The EnterWorks Data Model Migration function is performed in the Enable Classic UI. Perform the following steps to migrate the EnterWorks data model from one EnterWorks server to another.

NOTE: Before performing these steps, be sure there is a backup of the target Enable database in case migration failures necessitate restoring the database from the backup.

1. Log in to the source Enable (e.g., QA) Classic UI as a system administrator.
2. Click on the Migration option on the feature bar and select Migrate Out function. The Migrate Objects Out page appears.
3. Enter the name for the Migration file in the Zip and Specification file name fields. The actual file name will include a time-based number to ensure uniqueness.
4. Optionally select an existing Migration Specification file. This will pre-select the objects to be migrated.
5. Click Next. The Select Objects to Migrate page appears.
6. Click the checkbox next to any Profile in the Profiles section that has changes to be migrated. For example, if the character length of an attribute in the SKU Group repository has been increased, check the checkbox next to SKU Group.
7. If any Association groups (including order) have been changed, click the Check link at the top of the Association Groups section.
8. If any code set has been added or modified, click the checkbox next to that code set (or alternatively click the Check link at the top of the Code Set section).
9. If any changes have been made to the hierarchies or taxonomies, check its checkbox in the Hierarchies or Taxonomy section.
10. If any changes have been made to any transmission options, check its checkbox in the Transmission Options section.
11. If any changes or additions have been made to any Attribute Security Filters, check its checkbox in the Attribute Security Filters section.
12. If any changes or additions have been made to any Record Security Filters, check its checkbox in the Record Security Filters section.
13. If any changes or additions have been made to any repositories, check its checkbox in the Repositories section.
14. If any changes have been made to an Export/Publication/Syndication templates, check its checkbox in the Templates section.
15. If any changes or additions have been made to any Template Folders, check its checkbox in the Template Folders section. If the sequence has been changed on the folders, click the Check link to check all repository folders.
16. If any changes have been made to a Style Map, check its checkbox in the Style Maps section.
17. If any changes have been made to Style Map Folders, check its checkbox in the Style Map Folders section.
18. If any changes have been made to any import templates, check its checkbox in the Import Templates section.
19. Click Migrate.
20. Open the Job Monitor. The new migration job appears at the top of the list.
21. Repeatedly click Refresh to monitor the progress of the migration, until the Status shows “Completed”.
22. Copy the .zip and .msf files from the \Enterworks\shared\migration folder on the source system (e.g., QA) to the same location on the target system (e.g., PROD).
23. Log into the target Enable (e.g., PROD) Classic UI as user system.
24. Click on the Migration option on the feature bar and select Migrate In function. The Migrate Objects In page appears.
25. Select the .zip and .msf files that were just copied to the migration folder and click Next. The Select Objects to Migrate page appears.
26. Click the Overwrite All Check link. The checkboxes for all objects in the migration are checked.
27. Click Migrate.
28. Open the Job Monitor. The new migration job appears at the top of the list.
29. Repeatedly click Refresh to monitor the progress of the migration, until the Status shows “Completed”.
30. Click the Log File icon for the Migration Log for the Migrate In job in the Job Monitor page. A window containing the migration log file contents appears.
31. Review the contents of the log to ensure the expected objects were migrated. If the errors are substantial and cannot be quickly remedied, abort the migration attempt by restoring the target Enable database from the backup.