Migration from MSSQL to Postgresql

[Omer Nuri]

Hi everyone,

Does anyone migrated from MSSQL database to Postgresql database and can share the process?

We want to move all of our data from MSSQL to Postgresql and want to make sure we got all things covered (schema, copy data, etc)

Thank you,

Omer

[Peter Grundler]

Hi Omer,

I always use ClientCopy (https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/24.4.0/Automic%20Automation%20Guides/Content/Utilities/admin_AE_DB_ClientCopy.htm?Highlight=clientcopy). Alternatively you could export the entire MSSQL DB with AE.Unload and load the file into PostgreSQL with AE.Load

regards,
Peter

[Reginold DAlmeida]

There is no direct method to move from MSSQL to Postgresql. You could however use "client copy" to copy clients to the same or a different database or to delete existing clients. You can include all messages, statistics, reports, and version management objects of the source client. If the source client is copied for the first time, objects are also copied. 

AE DB Client Copy

[Michael Dolinek]

Hi @Omer Nuri

in order to mitigate the risk of incompatibilities in your scrip-code when switching from Microsoft SQL Server to PostgreSQL make sure to set the configuration item UC_SYSTEM_SETTINGS::FORCE_VARA_KEY_CI accordingly.

See https://docs.automic.com/documentation/webhelp/english/AA/26.0/DOCU/26.0/Automic%20Automation%20Guides/Content/AWA/Variables/UC_SYSTEM_SETTINGS/UC_SYSTEM_FORCE_VARA_KEY_CI.htm

Michael

[Omer Nuri]

Thank you all for the answers, i will look in the client copy documentation.

Beside the case sensitive difference, is there anything else to pay attention between the schemes?

Thank you,

Omer