Plan: DDOTGIS Oracle to SQL Server

Date

07 Jul 2020

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)