CCMDB Wiki

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

← Older edit
mNo edit summary
No edit summary
 
(29 intermediate revisions by the same user not shown)
Line 1: Line 1:
This page is about the update of [[Centralized data.mdb]] to the newer .accdb format.  
This page is about the update of Centralized_data.mdb to the newer .accdb format.  


== Reasons to do this ==
== Reasons to do this ==
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.accdb]] and [[Centralized_data.accdb]] to .accdb and done some basic testing, including sending. It seems to work.  
 
* Julie confirmed that SAS can read .accdbs and that she accesses this data through [[CFE]] anyways.
=== 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 ===
* Update to and encrypt centralized_data.accdb - update and encryption complete Ttenbergen 16:59, 2019 September 18 (CDT)
* In CCMDB.mdb
* In CCMDB.mdb
** update sending
** update sending - changed Ttenbergen 16:59, 2019 September 18 (CDT)
* In CFE
** getting error that can't link to newer format, so '''will need to change CCMDB.mdb as well''';
** update connecting
** updated [[CCMDB.accdb]] to [[CCMDB.accdb]]
* in push/pull/copy,  
** update [[Backup.bat]] - completed Ttenbergen 17:25, 2019 September 18 (CDT)
** update filename
** update [[Copy to local.bat]] - completed Ttenbergen 17:28, 2019 September 18 (CDT)
* '''''PHI process?
** update [[Updt all.bat]] - completed Ttenbergen 17:28, 2019 September 18 (CDT)
* '''''DSM process?
* In [[Centralized data front end.accdb]]
* '''''MCHP process?
** update connecting - complete and rolled out Ttenbergen 17:35, 2019 September 18 (CDT)
* \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\ push/pull/copy,  
** [[Push up centralized data.vbs]] - complete Ttenbergen 17:43, 2019 September 18 (CDT)
** [[Pull down centralized data.vbs]] - complete Ttenbergen 17:43, 2019 September 18 (CDT)
** [[Copy here only centralized data.vbs]] - complete Ttenbergen 17:43, 2019 September 18 (CDT)
* \\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 ==  
{{Related Articles}}
{{Related Articles}}
[[Category:IT Support]]
[[Category:Centralized_data.accdb]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Conversion_of_Centralized_data.mdb_to_Centralized_data.accdb"