public override ISaver Create(string connectionString, CdmVersions cdmVersion, string sourceSchema, string destinationSchema)
{
CdmVersion = cdmVersion;
SourceSchema = sourceSchema;
DestinationSchema = destinationSchema;
var odbc = new OdbcConnectionStringBuilder(connectionString);
var connectionStringTemplate = "Server={server};Port=5432;Database={database};User Id={username};Password={password};SslMode=Require;Trust Server Certificate=true";
var npgsqlConnectionString = connectionStringTemplate.Replace("{server}", odbc["server"].ToString())
.Replace("{database}", odbc["database"].ToString()).Replace("{username}", odbc["uid"].ToString())
.Replace("{password}", odbc["pwd"].ToString());
Console.WriteLine("npgsqlConnectionString=" + npgsqlConnectionString);
_connection = SqlConnectionHelper.OpenNpgsqlConnection(npgsqlConnectionString);
return(this);
}
public override ISaver Create(string connectionString, CdmVersions cdmVersion, string sourceSchema, string destinationSchema)
{
CdmVersion = cdmVersion;
SourceSchema = sourceSchema;
DestinationSchema = destinationSchema;
var odbc = new OdbcConnectionStringBuilder(connectionString);
//var connectionStringTemplate = "Server={server};Port=5432;Database={database};User Id={username};Password={password};SslMode=Require;Trust Server Certificate=true";
var connectionStringTemplate = "Server={server};Port={port};Database={database};User Id={username};Password={password}";
////TMP
//if (odbc["server"].ToString() == "10.110.1.7" ||
// odbc["server"].ToString() == "185.134.75.47" ||
// odbc["server"].ToString() == "192.168.20.47" ||
// odbc["server"].ToString() == "10.5.10.33")
// connectionStringTemplate = "Server={server};Port=5431;Database={database};User Id={username};Password={password}";
var npgsqlConnectionString = "";
if (odbc["port"] == null)
{
npgsqlConnectionString = connectionStringTemplate.Replace("{server}", odbc["server"].ToString())
.Replace("{database}", odbc["database"].ToString()).Replace("{username}", odbc["uid"].ToString())
.Replace("{password}", odbc["pwd"].ToString())
.Replace("{port}", "5432");
}
else
{
npgsqlConnectionString = connectionStringTemplate.Replace("{server}", odbc["server"].ToString())
.Replace("{database}", odbc["database"].ToString()).Replace("{username}", odbc["uid"].ToString())
.Replace("{password}", odbc["pwd"].ToString())
.Replace("{port}", odbc["port"].ToString());
}
//var npgsqlConnectionString = connectionStringTemplate.Replace("{server}", odbc["server"].ToString())
// .Replace("{database}", odbc["database"].ToString()).Replace("{username}", odbc["uid"].ToString())
// .Replace("{password}", odbc["pwd"].ToString());
Console.WriteLine("npgsqlConnectionString=" + npgsqlConnectionString);
_connection = SqlConnectionHelper.OpenNpgsqlConnection(npgsqlConnectionString);
return(this);
}
