The information in this article applies to:
Product: Metastorm BPM
Version: 7.x
Issue
Running the Migrator tool against a version 6.x database does not modify external tables that were created using the External Tables tool in the Metastorm Designer.
For example, columns of type varchar in map tables and Metastorm system tables are converted to nvarchar by the Migrator. However, varchar datatypes in external tables remain varchar.
Resolution
- This is by design. The External Tables tool is provided as a convenience. It is left to the user to determine if the external tables need to be altered to allow for the storage of unicode data and, if so, to run the appropriate ALTER TABLE commands.