How to migrate database from MSSQL to PostgreSQL

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

0 votes

2 answers

256 views

ANSWER



Hi Gregory,

Thank you for your interest. I don't need to just data import. I need to migrate users, groups, permissions and domain-workspace hierarchy. As you see I need all of them.

The document link below does not cover our situation.

https://doc.nuxeo.com/nxdoc/choosing-how-to-import-data-in-the-nuxeo-platform/

Could I get professional support from you about this?

0 votes



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,

0 votes