Conversion of Centralized data.mdb to Centralized data.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "TISS28.mdb" to "TISS28.accdb")
m (Text replacement - "ccmdb.mdb" to "ccmdb.accdb")
Line 13: Line 13:


=== Testing completed ===
=== Testing completed ===
I have converted both ccmdb.mdb and Centralized data.mdb to .accdb and done some basic testing, including sending. It seems to work.  
I have converted both ccmdb.accdb and Centralized data.mdb to .accdb and done some basic testing, including sending. It seems to work.  


=== Testing remaining ===
=== Testing remaining ===
Line 23: Line 23:
** update sending - changed Ttenbergen 16:59, 2019 September 18 (CDT)
** update sending - changed Ttenbergen 16:59, 2019 September 18 (CDT)
** getting error that can't link to newer format, so '''will need to change CCMDB.mdb as well''';
** getting error that can't link to newer format, so '''will need to change CCMDB.mdb as well''';
** updated ccmdb.mdb to ccmdb.accdb
** updated ccmdb.accdb to ccmdb.accdb
** update [[Backup.bat]] - completed Ttenbergen 17:25, 2019 September 18 (CDT)
** update [[Backup.bat]] - completed Ttenbergen 17:25, 2019 September 18 (CDT)
** update [[Copy to local.bat]] - completed Ttenbergen 17:28, 2019 September 18 (CDT)
** update [[Copy to local.bat]] - completed Ttenbergen 17:28, 2019 September 18 (CDT)

Revision as of 10:55, 2020 June 10

This page is about the update of Centralized data.mdb to the newer .accdb format.

Reasons to do this

  • Most immediately:
  • More generally:
    • bringing format up-to-date
    • better encryption

Plan

Uncertainties

This file is used in automation and linked data a lot of places. I anticipate that we will not find at least some of them until after the change. I also anticipate that the erros will be fail-safe and noisy, and then easy to fix.

Testing completed

I have converted both ccmdb.accdb and Centralized data.mdb to .accdb and done some basic testing, including sending. It seems to work.

Testing remaining

Julie confirmed that SAS can read .accdbs and that she accesses this data through CFE anyways.

Steps for update

  • Update to and encrypt centralized_data.accdb - update and encryption complete Ttenbergen 16:59, 2019 September 18 (CDT)
  • In CCMDB.mdb
    • update sending - changed Ttenbergen 16:59, 2019 September 18 (CDT)
    • getting error that can't link to newer format, so will need to change CCMDB.mdb as well;
    • updated ccmdb.accdb to ccmdb.accdb
    • update Backup.bat - completed Ttenbergen 17:25, 2019 September 18 (CDT)
    • update Copy to local.bat - completed Ttenbergen 17:28, 2019 September 18 (CDT)
    • update Updt all.bat - completed Ttenbergen 17:28, 2019 September 18 (CDT)
  • In Centralized data front end.accdb
    • update connecting - complete and rolled out Ttenbergen 17:35, 2019 September 18 (CDT)
  • \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\ push/pull/copy,
  • \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\PHI\PHI Loader.accdb
    • update var old_path - changed Ttenbergen 17:49, 2019 September 18 (CDT)
  • TISS28.accdb
    • update reconnect script - complete Ttenbergen 17:53, 2019 September 18 (CDT)
  • \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\DSM Labs Imports\DSM Labs Consistency check.accdb
    • update var Centralized_data - completed Ttenbergen 20:26, 2019 September 18 (CDT)
  • \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB_Special_Projects\MCHP\Master\MCHP Export.accdb
    • update function centralized_data - completed Ttenbergen 20:30, 2019 September 18 (CDT)

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Conversion_of_Centralized_data.mdb_to_Centralized_data.accdb&oldid=144701"