Sage 100

 View Only
  • 1.  SQL upgrade procedure.

    Posted 08-06-2022 01:46

    @Kevin Moyes

    did you post you new improved sage premium upgrade/migration.  I would be interested in seeing it.  


    just wondering,

      



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


  • 2.  RE: SQL upgrade procedure.

    Posted 08-08-2022 10:32
    Jim,
    I made requests of Sage to improve things, and the dev team is considering it.  What I explained to Elliott (...how real world situations often make the connection to a live source system difficult or impossible... what a pain it is to migrate from Premium to Premium when the source server is not available for a variety of reasons) was well received, and he sees the benefit of a method with less technical hurdles.  The basic idea is to allow migration with a copy of MAS90 and .BAK files of the databases (MAS_System and the company DBs).  Of course, this kind of data source for a migration would really help with Premium disaster recovery too.  Time will tell if anything comes of it... but no guarantees. 
    Is that what you mean? 


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 3.  RE: SQL upgrade procedure.

    Posted 08-09-2022 13:56
    yes,  Do you have a special method to do it when the Parallel menu entry is failing?

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



  • 4.  RE: SQL upgrade procedure.

    Posted 08-09-2022 14:05
    See the reply by @George Khairallah for the basics... Link

    @Carmen Cruz posted some instructions the MERGE method, which is basically what George refers to... linked from here.
    ​​

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 5.  RE: SQL upgrade procedure.

    Posted 08-09-2022 16:16
    Thanks @Kevin Moyes,

    this is exactly what I was looking for .  I thought you were the one that posted it .  it was George.  Anyways things for the links!!​

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



  • 6.  RE: SQL upgrade procedure.

    Posted 08-10-2022 12:09

    Hi Jim,

    Just seeing this.  Tell me what happened and I can help with how to address moving forward.

     


    Carmen Cruz
    Sage Consultant
    carmen.cruz@compudata.com
    215-969-1000 Ext. 279
    www.compudata.com
    Work Smarter... Together 

    CompuData, Inc. • 325 Chestnut St, Ste 700 • Philadelphia • PA • 19106





  • 7.  RE: SQL upgrade procedure.

    Posted 08-10-2022 12:12

    I just read the full email and there is a method to do exactly with Kevin is talking about below for when you cant get to the source server.  We should do a call.  Thoughts?

     


    Carmen Cruz
    Sage Consultant
    carmen.cruz@compudata.com
    215-969-1000 Ext. 279
    www.compudata.com
    Work Smarter... Together 

    CompuData, Inc. • 325 Chestnut St, Ste 700 • Philadelphia • PA • 19106