What to do after Upgrading GP and/or Migrating to a new SQL Server Article

What to do after Upgrading GP and/or Migrating to a new SQL Server Article

What to do after Upgrading GP and/or Migrating to a new SQL Server 

Adjusting Dynamic Budgets after a GP upgrade is typically just a 5 minute task, see the steps below.

If you migrated GP to a new SQL server, please send us the name/instance of the new SQL server and we will issue you a replacement license file.

 

Steps to migrate Dynamic Budgets to an upgraded GP SQL Server

Part 1 - The first portion of the upgrade is typically performed by the Customer's IT staff (Database Administrator)

  1.  Backup the DynamicBudgets database and Restore it into the new SQL server
  2.  If you migrated the dynbud SQL user to the new server skip to Part 2, otherwise perform steps 3,4,&5 
  3.  Delete and recreate the SQL user login “dynbud” from each of the following databases 
    1. DynamicBudgets
    2. Dynamics
    3. Each GP Company
  4. Grant Security for the dynbud SQL user with the following User Mapping
    1. DynamicBudgets (db_owner)
    2. Dynamics (db_datareader)
    3. Each GP Company (db_datareader)
  5. For each Dynamics GP company database run the following statement to enable the dynbud user with security rights to export budget details back to GP:
          Grant Insert, update, delete, select, references on GL00201 to [dynbud]


Part 2 - The following portion of the upgrade is typically performed by DynamicBudgets support staff

  1.  Replace the license.licx file in the DynamicBudgets-App folder with a new license for the new named SQL server
  2.  Launch the Server configuration Utility, run the upgrade process (verify that you are pointed to the new server)     
     
     
  3. Next you will need to reveal the lower half of the login screen to be able to change the server reference.
    Using notepad, Open the Client settings file found in  
    (DynamicBudgets-App\DynamicBudgets.Windows.Client.exe.config.xml)

    Change the HideDBConnectionOnLogin  value from 1  to 0, and save.
  4. Login to the application and change the designated server to the new server in the Database Connections drop down menu.
                                    

  5. Go back to (DynamicBudgets-App\DynamicBudgets.Windows.Client.exe.config.xml)
    Change the HideDBConnectionOnLogin  value from 0, back to 1, and save.
     
  6. Login to Dynamic Budgets, Open System Management \ Manage Servers
    manually update the name of the server, 
    (which can be found in the application header)
    Click Test Connection
    If successful, click save.


     

  7. Test by going to Reports \ Monthly Summary Accounts and try to drill down to transaction details for the live month.
  8. End

    • Related Articles

    • Upgrade Process-Including Moving to a New SQL Server Article

      If you are moving the DynamicBudgets_App share folder to a new server, please ensure the following DynamicBudgets-App  Client folder access:       1) Please ensure that the person who is to upgrade/patch the software has full control of the new ...

    • Create a New DB Database Tutorial

      PDF Tutorials  Interactive Tutorial Cropped Screenshots Full Page Screenshots           Purpose: During installation, a new database is created on the client's SQL server. Also, the client will create a security user that gives us read-only access to ...

    • Export Budget to GP Article

          Tutorial Link Note: For recovery purposes, Dynamic Budgets maintains an audit trail of all export sessions.  A snapshot of the before state of the records in Great Plains is captured as well as the batch of account records transmitted during the ...

    • Manage Servers Article

          Tutorial Link Purpose: To build a link to the SQL server(s) where the ERP system(s) are located. Dynamic Budgets (DB) can be installed in a single SQL instance or distributed across multiple linked SQL servers. ​ This screen is the first step in ...

    • Upgrading Dynamic Budgets Article

      1) Download the zip file 2) Extract/unzip the DynamicBudgets-App folder only.   To unzip right-click the folder, click "Extract All", and the folder will unzip to the same directory as the original zip folder. 3) Copy/paste the files in the ...