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

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
mNo edit summary
Line 9: Line 9:


== Plan ==
== 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 ===
=== 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.mdb and Centralized data.mdb to .accdb and done some basic testing, including sending. It seems to work.  


=== Testing remaining ===
=== Testing remaining ===
{{Discuss | who = Julie | question = Could you test if your SAS program can access the .accdb version of this with minimal changes? A test version is in regional server\output\centralized_data.accdb
}}
{{Discuss | Anyting else anyone else can think of to test? }}


=== Steps for update ===
=== Steps for update ===
Line 22: Line 29:
** update filename
** update filename
* '''''PHI process?
* '''''PHI process?
* '''''DSM process?
* '''''MCHP process?
== Related articles ==
{{Related Articles}}

Revision as of 13:14, 12 September 2019

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.mdb and Centralized data.mdb to .accdb and done some basic testing, including sending. It seems to work.

Testing remaining

Could you test if your SAS program can access the .accdb version of this with minimal changes? A test version is in regional server\output\centralized_data.accdb

  • SMW


  • Cargo


  • Categories
Anyting else anyone else can think of to test?
  • SMW


  • Cargo


  • Categories

Steps for update

  • In CCMDB.mdb
    • update sending
  • In CFE
    • update connecting
  • in push/pull/copy,
    • update filename
  • PHI process?
  • DSM process?
  • MCHP process?

Related articles

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