Sage 100

 View Only
  • 1.  Can someone jog my memory on 4.50 premium upgrade procedures please?

    Posted 08-02-2019 17:56
    It's been a while since I had to upgrade such an old premium version.

    Here's the scenario: Final goal is to upgrade to 2018 premium.

    Clients production install is 4.50.3 on it's own server and SQL instance. They don't want to touch their production install.

    I have 2018 installed on a new server with it's own SQL instance and also a 4.50.3 install with it's own unique instance.

    The plan is to migrate from production to the new 4.50.3 version and then apply PU8 to it. After that, migrate from 4.50.8 to 2018.

    I ran the migrate.exe and was confused by the instructions on the splash screen.

    1. Select Library Master Utilities menu > Pre-Migration to back up your system files - I did this.

    2. Manually copy the source MAS_System database to be migrated to the new SQL server instance when migrating system files. Migration system files is required for an initial migration. ???? I already have a MAS_System database in my new SQL instance which I just backed up by using the pre-migration utility. Do I need to over write this database? This is my main concern, do I really have to overwrite the MAS_System database or not?
    The source company databases must be copied to the new SQL server instance for each company to be migrated. Is this a straight forward file copy from one server to another or do I need to go through a restore, or attach database process?

    Any insight is appreciated.
    John

    ------------------------------
    John Kerr
    Net at Work
    ------------------------------


  • 2.  RE: Can someone jog my memory on 4.50 premium upgrade procedures please?

    Posted 08-02-2019 18:05
      |   view attached
    Did you see these instructions on the SAGE KB.

    I think that will would for you.



    ------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ------------------------------



  • 3.  RE: Can someone jog my memory on 4.50 premium upgrade procedures please?

    Posted 08-02-2019 18:12
    I will review this document, but my main problem right now is to get the 4.50.3 migrated to the new server. I'm just not sure of the steps outlined in the splash screen. I've done SQL upgrades in versions 2015 through 2018, I just don't remember having to follow those steps in 4.50.

    Thanks Jim

    ------------------------------
    John Kerr
    Net at Work
    ------------------------------



  • 4.  RE: Can someone jog my memory on 4.50 premium upgrade procedures please?

    Posted 08-02-2019 18:09
      |   view attached
    This one will be easier to read..  DOH!!

    ------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ------------------------------



  • 5.  RE: Can someone jog my memory on 4.50 premium upgrade procedures please?

    Posted 08-02-2019 21:27
    Yes, that was much easier to read. Thanks again.

    Almost got through the migration but some problem came up on the CRM side. Need to call in my CRM guys to take a look on Monday.

    ------------------------------
    John Kerr
    Net at Work
    ------------------------------