update TB_FONTE_DADOS set FON_URL = replace(replace(FON_URL, 'jdbc:jtds:sqlserver', 'jdbc:sqlserver'), SUBSTRING(FON_URL, charindex('/', replace(FON_URL, '//', '__')), len(FON_URL)), ';databaseName=' + SUBSTRING(FON_URL, charindex('/', replace(FON_URL, '//', '__')) + 1, len(FON_URL))) where FON_URL like '%:sqlserver:%' and FON_URL not like '%;databaseName=%' update TB_FONTE_DADOS set FON_DRIVER = 'com.microsoft.sqlserver.jdbc.SQLServerDriver' where FON_DRIVER = 'net.sourceforge.jtds.jdbc.Driver' update TB_FONTE_DADOS set FON_URL = replace(FON_URL, 'jdbc:oracle:thin://@', 'jdbc:oracle:thin:@') where FON_URL like 'jdbc:oracle:thin://@%'