How to migrate database from MSSQL to PostgreSQL

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Fatih_Kucuk

Hi guys,

I decided to change the database type for some performance issues. I am using mssql for the database. Now, I want to use postgresql. This is a test environment but I have to change the production environment at the end.

I can see a lot of data structure differently between two databases as far as. It will be really hard and painful to do that. Do you have any idea how can I do easily way to do that?

For example ;

select * from ancestors a

postgresql

"{b8441024-3952-40f0-af10-3965d96498a9,824c1016-b6c9-4930-9ffe-c95a3ff56b00,7e5b92c4-d3cb-42a5-a264-5b94dca00e38}"

mssql

044677e6-d56a-4fc1-a93f-dff72c69362b

Gregory_Carlin

Hello,

The easiest way, I think, is to have two Nuxeo instances, one with MySQL and the other with Postgres, and perform data migration, rather than using the same instance with two different databases. You shouldn't care anyway about the way Nuxeo stores the document property within the database: what matters is the way you need to retrieve information, and it is always the same (NXQL, Java API, REST API...), independently of the database vendor.

Check Choosing How to Import Data in the Nuxeo Platform

Regards,