ANSI Conversion Utility

iMIS Desktop requires ANSI settings to be enabled at all times. Whenever Desktop creates a connection (ODBC or otherwise), it does so with all ANSI options turned ON. To ensure that that the entire iMIS database has the correct ANSI settings, the upgrade utility rebuilds all tables and recreates all stored procedures, triggers, functions, and views.

Note: Because of this extensive rebuilding, expect upgrading to be significantly slower for very large databases. Before upgrading, check that you have ample free disk space relative to the size of your database, as these tables will be copied during the process of conversion and rebuilding.