
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#/');




-- 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#');
update tm_test_description_aud set description = replace(description, '#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#');








