Click here to download the demo of the NEW CINCH UPGRADE Process.
...
This chapter describes enhancements made to the installation process of CINCH. These enhancements have been placed in the Install Guide which now reflects both an Installing CINCH and Upgrading CINCH section. New installations and upgrades from versions prior to 18.56 will need to upgrade to 18.56 first. (CIN-5336)
This chapter contains the following section:
...
(Microsoft Dynamics GP >> Maintenance >> CINCH Maintenance >> Table Utility)
WARNINGS:
· You must be logged in as “sa” or “DYNSA” to open the Table Utility window.
· The table update process is a SINGLE USER situation. Do NOT allow one user to update one company while another user attempts to update another company. During the table update process existing data is copied from the company database to a tempdb database. If two users try to update the same tempdb at the same time the update WILL error.
2. Product has replaced the Product From field and scrolling window and will default with CINCH or CINCH.
...
· Upon upgrade, the un-chunking process will move the installed version within the IRGNMainSETP table’s IRVersion field to the IRVersionPrev field. It is the IRVersionPrev value that will default into the Upgrade From field.
WARNING – : Manually deleting, renaming, or restoring the CINCH/Intellego dictionary will not update the IRGNMainSETP file.
b. Drop-down will display versions starting with 18.56. The version is based on the initial release of the version which is released each December.
...
6. Selected Tables displays tables either selected individually and/or selected by the Upgrade From expansion button.
WARNING: The system will not stop or warn a user from adding an additional table or removing a selected upgrade table.
7. Backfills
a. If upgrading only one version, follow the backfill instructions indicated within the installation guide.
...
SQLCompanyFunctionsR1857.sql
SQLCompanyViewsR1857.sql
SQLCompanyProceduresR1857.sql
SQLCompanyTriggersR1857.sql
SQLCompanyEconnectProcsR1857.sql
IRGrant.sql
SQL command exec IRCSBindDefAll
WARNING: The SQL command “exec IRCSBindDefAll” included in the SQLCompanyCINCHR1857.sql could take up to 15 minutes to complete and is the same process that runs when using the Bind Defaults window (Microsoft Dynamics GP >> Maintenance >> CINCH Maintenance >> Bind Defaults.)