Migrate Nuxeo 5.8 PostgreSQL database to SQL Server

Hello,

I have an instance Nuxeo 5.8 + PostgreSQL. I need to migrate the database from PostgreSQL to SQL Server.

It's possible?

Also.. It's possible create a empty instance with SQL Server and then, migrate all documents?

Thanks in advance.

Kind regards,

0 votes

1 answers

1283 views

ANSWER



Hi,

Did you try to simply perform an SQL export from PostgreSQL and then import the data into SQLServer?

1 votes



Hi,

I've tried it but have some issues with some fields. I've got a dump bigger than 1GB and is so slowly this operation.

I've got the possibility to export the domains and import in the new instance but, ¿can export/import the users and permissions? :\

Thanks in advance.

Kind regards,

09/30/2014

Finally i solved it using a 3rd part software.

Regards,

11/26/2014