\c pam-simulator
--select value,variable from app_configuration where value like '%http%';
update app_configuration set value = replace(value, '#old_url_value#', '#url_value#');

\c gazelle-hl7-validator
--select value,variable from app_configuration where value like '%http%';
update app_configuration set value = replace(value, '#old_url_value#', '#url_value#');

\c svs-simulator
--select value,variable from app_configuration where value like '%http%';
update app_configuration set value = replace(value, '#old_url_value#', '#url_value#');

\c demographic-data-server
update app_configuration set value = replace(value, '#old_url_value#', '#url_value#');

