Procedure for Running the Unified Typing Migration Tool on Multiple Processes Using the Same Type

In some databases, the majority of objects may be of the same type. The process that migrates objects of that type may take a while compared to the other processes. To balance the number of objects of the same type to be migrated in each process, use the "-filter" option along with the creation date. The steps below provide an example of four processes used to migrate objects of the TypeToMigrated type.

See Also
Procedure for Preparing the Migration
Running the Migration
Procedure for Parallelizing Migration Processes

Command to Launch in a MQL PromptReturned String
1eval expr 'median originated' on temp query bus TypeToMigrate * *;7/14/2016 4:09:28 AM
2eval expr 'median originated' on temp query bus TypeToMigrate * * where where 'originated<=7/14/2016 ';"7/6/2016 3:33:04 AM
3eval expr 'median originated' on temp query bus TypeToMigrate * * where where 'originated>7/14/2016 '; 8/14/2016 6:32:36 AM
Note: You can run the Unified Typing Migration Tool on four processes using following additional options:
  • Process 1: -types TypeToMigrate –filter 'originated<=7/6/2016 '
  • Process 2: -types TypeToMigrate –filter 'originated>7/6/2016 and originated<=7/14/2016'
  • Process 3: -types TypeToMigrate –filter 'originated>7/14/2016 and originated<=8/14/2016'
  • Process 4: -types TypeToMigrate –filter 'originated>8/14/2016'