I want to configure the symmetricds community edition on my os cluster environment which has one virtual IP and 2 physical IP. I want to replicate data from MS-SQL to this cluster environment of PostgreSQL server. I have doubt about the properties file on both the node i.e on MS-SQL and PostgreSQL.
Can anyone tell me what will be my property file for this environment? It will be very helpful for me
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You should have 1 properties file for each logical database. Say you have 1 MS-SQL db, and 2 PostgresSQL servers - acting as a cluster, so acting like 1 database. In that case, you would have 1 property file for the MSSQL, and 1 property file for the Postgres cluster.
Hope that helps and let me know if I misunderstood.
Mark
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Dear All,
I want to configure the symmetricds community edition on my os cluster environment which has one virtual IP and 2 physical IP. I want to replicate data from MS-SQL to this cluster environment of PostgreSQL server. I have doubt about the properties file on both the node i.e on MS-SQL and PostgreSQL.
Can anyone tell me what will be my property file for this environment? It will be very helpful for me
Thanks
Nitesh,
You should have 1 properties file for each logical database. Say you have 1 MS-SQL db, and 2 PostgresSQL servers - acting as a cluster, so acting like 1 database. In that case, you would have 1 property file for the MSSQL, and 1 property file for the Postgres cluster.
Hope that helps and let me know if I misunderstood.
Mark