AnsweredAssumed Answered

how to Migrate data(with schema) from MSSQL to PostgreSQL?

Question asked by Tlham123 on Feb 28, 2019
Latest reply on Mar 19, 2019 by asrujit_pb

i have a ARCSDE enterprise geodatabase in MSSSQL Server 2008. I want to replace MSSQL Server with PostgreSQL.

i have setup the enterprise geodatabase in PostgreSQL and now want ti import the data along with the schema to PostgreSQL.

i tried with export/import XML Workspace however my data is quite big(around 7GB) and its taking a very long time plus its giving some error while importing the XML Workspace.

 

can anyone help me how to  import data (with schema) from MSSQL to PostgreSQL ?

Outcomes