Dynamics SL Upgrade Methodology
Is it time for an upgrade to the latest version of Dynamics SL? If so, Crestwood Associates is poised to help you through this complex process. We bring resources to the table with years of expertise to make the experience as stress free as possible for our customers.
Here’s what we do:
- Verify which version of SL and SQL is being upgraded. This determines whether it will take 1 or 2 passes to upgrade the database in SQL.
- Verify local admin on all servers
- Turn off UAC on new server. “Must reboot after”
- Verify .net 3.5 or later is installed on SL Server.
- Install/Configure SQL (make sure you set SQL/Windows compatibility, also set up your user as administrator)
- Download software – SL 2015, CU2 (make sure to include 3rd party and integrated products).
- Create new DBs in new SQL Server (name must match old server) System and App dbs.
- Backup databases from old version (then copy to new SQL server) and restore to new SQL server databases.
- Install SL2015 (locate which version of SL to install by logging into current SL, go to Help, About – should show Professional, Adv Mgmt, etc.)
- Install SL2015 CU2
- Update Domain table in system db in SQL – server name to new server name
- SL Database Maintenance (under Administrative Tools) Upgrade databases – select Windows Authorization – use your user as admin user
- Change to SQL Authorization (if using Windows Authorization, change back to Windows Authorization again) – Master80 is created from this step
- Sync Ownership (make sure everyone is out if SL)
- Log onto old server, export Customizations from within Dynamics SL (Administration, Export Customizations – only All Users ones, not Self).
- Copy over Usr_rpts directory from old server to new directory, same place.
- Delete custom, custom2 and customvba tables from new system database in SQL
- Download SL unlocking keys from Partnersource
- Download all 3rd party unlocking keys from 3rd party vendor (make sure they are current on enhancement)
- Log into SL, register, log out
- Log back into SL, Run DBUpdate in SL
- Install BSL Components
- Import customizations (Administration, Import Customizations)
- Share Microsoft Dynamics folder/Security – give full permissions to share and full permissions to Security
- Install Crystal 2008 (from install cd)
- Install PSTL/Bus analyzer
- Install SL User Guides/copy MR user guide
- Install 3rd party products if applicable
- Modify solomon.ini (change FRx, Crystal and MR locations, for go-live), update QQ lines/pages, AP quick check
Get users going:
- Add roles for Quick Query
- Set security for all SQL long user id’s (CD…./E…, etc.) to Read/Write SQL for App/System dbs
- create backup maintenance plan in SQL
- Install any applicable hotfixes
- Work with client to begin User Acceptance Testing (UAT)
- Testing can take a week or several months depending on the environment
- Provide New Feature training to users
- Once the UAT has been completed and signoff has been received confirming that the test environment is fully functional, the live upgrade is scheduled
- Access to the old server is removed to prevent entering data into the wrong database
- Take a new backup of databases
- Restore database over test and cycle back through previous steps to upgrade databases
- **restore test system db back (*only during live upgrade). This step ensures that the changes that were made during test are intact
- Resolve any issues documented during testing phase
- Go Live
- Post Go Live – Crestwood is here to support you
Read more on things to consider and planning tips for your upgrade.
If you have further questions, or want to schedule your upgrade, contact us at firstname.lastname@example.org