All instances are inserted into the Repository 2.0 tables on branch 0, version 0, in a non-frozen state.
The Migration Wizard checks all the Repository 1.0 Type Information Model tables for any additional columns that are created using the SQL ALTER statement, and are not represented by the Type Information Model model. The detection triggers a dialog box and a text file noting these tables to the user. It is the user's responsibility to recreate these tables in the Repository 2.0.
Users can create their own tables with a foreign key relationship back against the Type Information Model tables, based on the InternalID of each repository object. The Migration Wizard will copy all rows to the Repository 2.0 tables, leaving the InternalID unchanged. This prevents loss of referential integrity, and preserves foreign key dependencies based upon InternalID. The Migration Wizard does not move, copy, or alter user tables. Note that user tables are not the same as user-created Information Models.
The Migration Wizard focuses only upon the Type Information Model tables and any Type Information Model instance data tables defined in the repository. All tables named in the Information Models will be converted.
Both Repository 1.0 and Repository 2.0 databases are accessed via Remote Data Access (RDO)/Open Database Connectivity (ODBC) connections. This requires the user to have predefined the ODBC DSNs for SQL Server databases. The Migration Wizard generates temporary DSNs for the Access MDBs that are not already associated with DSNs.