26 reputation
2
bio website
location
age
visits member for 1 year, 10 months
seen Jan 31 '13 at 15:25

Nov
10
awarded  Supporter
Nov
10
comment Can you synchronize tables between ArcSDE(MSSQL) and PostgreSQL(PostGIS) regularly?
@R.K. This data will be used in the ESRI environment for further analysis before the ETL to PostGIS, hence stuck with SDE/PostGIS ETL. This is why using SQL server as a data store isn't an option at least for some of our data. Also the tables have been registered with ArcSDE geodatabases they aren't technically SQL server native. I converted the ETL model to python and will run as a job but this is like a bulkoad and I need to be able to update the table with each ETL. Not sure of the postgres commands to update or merge additional data after the first import and how to auto execute that.
Nov
8
awarded  Student
Nov
8
asked Can you synchronize tables between ArcSDE(MSSQL) and PostgreSQL(PostGIS) regularly?