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