NOTES:
When upgrading from a version of mart server prior to 9.8 version to a later version of the mart server you should first upgrade to 9.8 mart server as an intermediate step and then upgrade to the later version.
If you are upgrading from 2020 R1 you need to first upgrade to 2020 r1 sp1 and then to 2020 r2 before you can upgrade to a later version.
Also, when running the mart configure window to update the database please make sure that the mart server service (or server) is stopped while performing the upgrade.
Upgrading erwin DM Workgroup (Mart) edition to v. 2020 R2
When using erwin Data Modeler (DM) with Workgroup, both erwin DM and Mart will need to be on the same version and bit-size (32- or 64 bit). The target database where Mart resides can differ in bit-size, but the connectivity part from erwin DM to Mart will need to be same bit size. This means that when upgrading to erwin DM 2020 R2, the Workgroup (Mart) will also need to be upgraded. Here are the steps to do it.
Upgrading to erwin DM Workgroup (Mart) edition on the existing database
Figure 1
Figure 2
Figure 3
Figure 4
Figure 5
Figure 6
Figure 7
Figure 8
Figure 9
Figure 10
The system restarts.
Configure Mart
Figure 11
Figure 12
Figure 13
Figure 14
For more information on performance on Report Data conversion, please click on the URL below.
Figure 15
The Mart Server Upgrade log does not need to be consulted unless you had an error during the upgrade. The log file is stored in: C:\Users\username\AppData\Local\ERwin\Mart Server\logs
Your mart server is now upgraded to the latest version.
====================================================================
Upgrading to erwin DM Workgroup (Mart) edition on a later/different version of the same/existing database
First, make sure this new database version is supported. See the mart server release notes.
Second, upgrade your DBMS to the later or different version.
Third, upgrade your mart server as in the instructions above.
====================================================================
Upgrading to erwin DM Workgroup (Mart) edition on a different supported database
First, make sure this new database version is supported. Please see the MartServer release notes.
Second, check out all your models from the Mart Server and save them offline. We have java scripts that can also do that for you automatically, please see Java scripts that automatically save a mart's models offline to a drive
Third, create a new Mart Server on the second different supported database using the latest version of the software. You may download that software from this web page erwin DM Downloads & Guides
Fourth, if desired, recreate the library structure in the new Mart using either erwin DM or the Mart Administrator.
Fifth, check all the models into the new mart server using erwin DM.
==================================================================
The steps above are for installing Mart on a SQL Server database. For other supported databases, e.g. Oracle, PostgreSQL, the steps are simple, but a few commands are a bit different which can be seen in the Administrative Guide at the following URL:
NOTE: If using Oracle DBMS please make sure your database privileges are in place. If your database user has the DBA role these privileges are discussed in the mart server release notes, especially see step 8, “Grant the Oracle privileges to the installer role”. If the database user does not have the DBA Role, please see this article for the permissions required, How to NOT use the DBA Role when installing or upgrading an Oracle mart. Also, how to use ONE role instead of two roles.
