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