Plan: DDOTGIS Oracle to SQL Server

Date

07 Jul 2020

Attendees

• James Graham (Deactivated)

• Faisal Khan (Unlicensed)

• Ramakrishna Nimmagadda (Unlicensed)
• Frank Wang
• Josh Lay
• Matt Crossett
• Mario Field
• Matt Sokol
• Tim Koonce

Goals

New Prod DB:  DDOTSQLGIS01

• New GIS DB: 
  • Machine:  DDOTSQLGIS01
  • IP address: 10.83.49.161
  • Port: 1433
• List of Data To Migrate:   https://dcgovict-my.sharepoint.com/:x:/g/personal/jgraham_ddot_dc_gov/EWzoXIDaADJIszsi3t-rAi8Bq6vyiPodki5HUqysvKI34A?e=pUa6U2
• List of steps:
  • Migration Date possibilities: 
    •  17 Jul 2020
    • 24 Jul 2020
    • 31 Jul 2020 
  • OCTO needs to do firewall routing request (Mario & Frank)
  • OCTO send over list of MXDs (Josh)
  • DDOT will take MXDs list and repoint to proper source
  • DDOT will send back MXDs to OCTO
  • DDOT will send list of services that can be retired
  • OCTO will publish to dev/staging
  • DDOT will check/test services on dev/staging
  • Notify DDOT Users
    • Send users wiki/info page.
  • Day of Migration/switch-over:
    • OCTO disables map services
    • DDOT stops access to DDOTGIS Oracle DB (for all non-admin users)
    • DDOT Copies latest records over to new prod
    • DDOT Notifies all-good to OCTO
    • OCTO will publish new connections to prod map services
    • DDOT will check services
    • OCTO ETLs need to be repointed to DDOTSQLGIS01
    • OCTO needs to publish Open Data datasets
  • OCTO needs to retire unmigrated/retired datasets (see spreadsheet linked above)