Post-conversion tasks
The following tasks can help you ensure the quality of your data conversion, and some tasks must be performed to ensure proper processing.
Post-conversion data validation scripts
You can use the following queries with iMIS Workbook Converter migrations to check for any issues:
- Committees: Run this query on a source database to get a list of all the committees and their members, and check resulting data in 20-300 (search for the committee and check against the roster there). Compare names, roles, and in cases where the membership is date-limited, the effective and expiration dates of membership:
SELECT Activity.Product_Code, Committee_Position.TITLE, Name.FULL_NAME, Name.COMPANY, Activity.ACTION_CODES, Activity.EFFECTIVE_DATE, Activity.THRU_DATE, committee_Position.RANK, Activity.TRANSACTION_DATE from Activity INNER JOIN Name on Name.ID = Activity.ID LEFT OUTER JOIN Committee_Position on Committee_Position.POSITION_CODE = Activity.ACTION_CODES Where Activity.ACTIVITY_TYPE = 'COMMITTEE' AND Activity.PRODUCT_CODE LIKE 'COMMITTEE/%' order by Product_Code
select COUNT(i.ContactKey) as CompanyRecords, InstituteName as CompanyName from Institute i, ContactMain cm where i.ContactKey = cm.ContactKey group by InstituteName having COUNT(i.contactkey)>1
Once the data conversion is complete, open a Support Ticket through the ASI Support Portal, and request Cloud Services to retrieve the database from the SQL sandbox and restore the database back to production. This only applies if you are running the conversion on a test environment.
If running the conversion on a production environment, update the ticket with ASI hosting to remove access to the application server.