Data Export/Import of %SYS.%Library.sys_SQLConnection
I am trying to migrate our SQL Connections from HealthShare Health Connect 2018.1.3 to IRIS HealthShare Health Connect 2022.2 using the Data Export/Import Wizard through the Management Portal. I am able to export the data fine, but I am running into issues trying to Import it into 2022.2 using the Data Import Wizard. When I run through the steps it is not importing everything from the txt file I created from 2018.1.3. I would rather not have to rekey all the connections if possible.
Here is the Background Task Error Log
Is there a way around this Validation error? Should I not export the passwords then just rekey the passwords into 2022.2?
Password is stored in encrypted form and that's causing your errors.
I think it might be easier to transfer
^%SYS("sql","ODBCCONNECTION")
global.I will give that a try also, part of my problem was leaving Data Validation on when I did the import.