AnsweredAssumed Answered

How to migrate SQLserver data to PostgreSQL?

Question asked by dbecker88 on May 31, 2017
Latest reply on Jun 1, 2017 by dbecker88

Have several sde geodatabases stored in SQL Server Express instance.

Just created new Linux Ubuntu instance of PostgreSQL, added st_geometry.so file to /lib.

 

I used the create enterprise geodatabase tool in ArcMap; sucessfully created sde gdb on PostgreSQL server.

 

To migrate the data:

1) export XML workspace file from SQL server sde gdb

2) attempt to import the XML workspace file to the PostgreSQL sde gdb

 

Error:

"database user name and current user schema do not match".

 

Can someone explain how to migrate the data to new PostgreSQL instance?

 

thanks.

Outcomes