\c assertion-manager
--select value,variable from app_configuration where value like '%http%';
update app_configuration set value = '#url_value#/gazelle/rest/' where variable = 'gazelle_test-management-url';
update app_configuration set value = '#url_value#/AssertionManagerGui' where variable = 'application_url';
update app_configuration set value = '#url_value#/AssertionManagerGui/rest' where variable = 'assertion_manager_rest_url';
update app_configuration set value = '#url_value#/docs/user_guides/UserGuide-AssertionManager.pdf' where variable = 'documentation_url';

UPDATE am_assertions_applies_to set linked_entity_provider='#url_value#/gazelle';
UPDATE am_assertions_applies_to set linked_entity_permalink=replace(linked_entity_permalink,'#old_url_value#/','#url_value#/');
UPDATE am_assertions_links set linked_entity_permalink=replace(linked_entity_permalink,'#old_url_value#/','#url_value#/');
update am_oasis_ref_source_item set uri=replace(uri,'#old_url_value#/','#url_value#/')  where uri like '#old_url_value#/%';
UPDATE am_mbv_service set url=replace(url,'#old_url_value#/','#url_value#/');

\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 gazelle
--select preference_value,preference_name from cmn_application_preference where preference_value like '%http%';
update cmn_application_preference set preference_value = replace(preference_value, '#old_url_value#', '#url_value#');

-- select url from tm_test_roles where url is not null and url != '';
update tm_test_roles set url = replace(url, '#old_url_value#', '#url_value#') where url != '';

-- select url_doc from tm_test_roles where url_doc is not null and url_doc != '';
update tm_test_roles set url_doc = '#url_value#/gazelle-documentation' where url_doc is not null and url_doc != '';

-- update URL which are set in test description
update tm_test_description set description = replace(description, '#old_url_value#', '#url_value#');

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

\c evs-client-prod
update cmn_application_preference set preference_value = replace(preference_value, '#old_url_value#', '#url_value#');
update evsc_validation_service set wsdl = replace(wsdl, '#old_url_value#', '#url_value#');
update evsc_calling_tool set url = replace(url, '#old_url_value#', '#url_value#');
update evsc_validation_service set xsl_location = replace(xsl_location, '#old_url_value#', '#url_value#');

\c cda-generator
update cmn_application_preference set preference_value = replace(preference_value, '#old_url_value#', '#url_value#');

\c svs-simulator
update app_configuration set value = replace(value, '#old_url_value#', '#url_value#');
update system_configuration set url = replace(url, '#old_url_value#', '#url_value#');

\c xdstar-client
update app_configuration set value = replace(value, '#old_url_value#', '#url_value#');
update system_configuration set url = replace(url, '#old_url_value#', '#url_value#');

\c schematron-validator-prod
update app_configuration set value = replace(value, '#old_url_value#', '#url_value#');

\c order-manager
update app_configuration set value = replace(value, '#old_url_value#', '#url_value#');

\c proxy
update app_configuration set value = replace(value, '#old_url_value#', '#url_value#');

\c xdw-simulator
update app_configuration set value = replace(value, '#old_url_value#', '#url_value#');

\c transformation
update app_configuration set value = replace(value, '#old_url_value#', '#url_value#');