New post
Question
Scott Roth · Dec 14, 2022

Data Export/Import of %SYS.%Library.sys_SQLConnection

#SQL #System Administration #InterSystems IRIS

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?

$ZV: IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2022.2 (Build 368U) Fri Oct 21 2022 16:36:49 EDT
0
0 116
Discussion (2)1
Log in or sign up to continue
Eduard Lebedyuk · Dec 16, 2022

Password is stored in encrypted form and that's causing your errors.

I think it might be easier to transfer ^%SYS("sql","ODBCCONNECTION") global.

0 0
Scott Roth · Dec 16, 2022

I will give that a try also, part of my problem was leaving Data Validation on when I did the import.

0 0