The Universal Schema is Continuously Evolving

The Universal Database schema continually undergoes slight modifications in order to continually upgrade the migration experience.  In most cases, these changes are minor and will not interrupt an in-progress migration, however, sometimes you may need to make manual adjustments to a legacy UM-database to make it compatible with the current version of the Universal Migrator.

Identifying a Database that Needs Upgrading

If you are attempting to perform a migration and you get messages such as:

1. Invalid column name 'Final_DisplayOrder'
2. Invalid column name 'Final_Created_OnBehalfOf'

or

this means the schema has changed and you need to apply manual adjustments to make the legacy database compatible with the current version of the Universal Migrator.

Running a Mass-Alter Script

To perform a mass-alter script, run a command like the following:

1. exec sp_MSforeachtable '
2. 
   
3. --Notice that single quotes are put in twice.
4. alter table ? add Final_Created_OnBehalfOf nvarchar(MAX) default ''''
5. 
   
6. '