How to upgrade a GoldMine 9.0.x secondary database to a newer GoldMine Premium Edition?

Version 1

    Details

    We upgraded the main database from 9.0.x to 2015.2.0.x and now we need to know how do we bring up a secondary database from 9.0.x to the current version/


    Resolution

     

    NOTE: While the work below is being performed it is best to have users logged out of GoldMine.  This is important so that users do not inadvertently become connected to a database other than the primary production database.

    NOTE: The steps below are for upgrading a database that is 9.0.x and higher to a newer GoldMine version such as GoldMine 2015.x.  If attempting to upgrade a version of GoldMine older than 9.0.0.x please contact a GoldMine Solutions Partner or the GoldMine Technical Support Desk.

    NOTE: It is import to make backups of both the database that is being upgraded and the current production database prior to upgrading.  This is important in the case that something is changed or accessed that should not have been changed or accessed.

    1 - Restore the 9.x database to the current SQL instance that is being used by the GoldMine production system.
    NOTE: It is important to know if the old database was a "Full" database containing both GoldMine Tables and Contact Set tables or just a Contact Set database containing only Contact Set tables.  The easiest way to determine this is once the dabase is restored in SQL, expand "Databases" in SQL Server Management Studio and then expand "Tables" of the restored database.

    2 - Below is what a "Full" database set of tables looks like:

    3 - Below is what a "Contact Set" only database set of tables looks like (NOTE: Most tables begin with 'CONT' and there are far fewer tables as the "Full" database.

    4 - Login to the production GoldMine system as a user with MASTER rights.
    5 - Click Help >> About GoldMine >> 'System' button.
    6 - Verify the current database that is being used for GoldMine Files (GMBase tables) and Contact Files (Contact tables).
    7 - Create an alias to the resotred.bak file(s)/database(s) from the old server.  This is done in Tools >> Databases >> Alias Manager.
    8 - Attach the GoldMine database in Tools >> Databases >> Open Database >> Attach.
    9 - Open the restored database using Tools >> Options >> Login tab.  - Change the "GoldMine database" and "Default contact database" to the restored database.  NOTE: If the old database is a Contact Set only database then just change the "Default contact database".  If changing the GoldMine database at the same time because the old database is a full database (has both GoldMine base tables and Contact set tables then at this time GoldMine will close and the login screen will show again.  If this is the case then login to GoldMine again as a user with MASTER rights.  If only upgrading a Contact Set database then there will be a prompt to upgrade the database >> select Yes/OK.
    10 - Make a new backup of the upgraded databases in SQL Server Management Studio.
    11 - Before letting users back into GoldMine please verify the correct database is connected for both the GoldMine Tables (GoldMine Files) and the Contact Set tables (Contact Files).

    Other helpful Knowledge Articles around this topic are as follows:
    16194 - How to identify the database / contact set I have open?
    11928 - How do we create a Contact Set only database or secondary Contact database?  ("Contact Set only" database)
    13858 - Need instructions to create a new database with blank tables. ("Full" database)