Info on postgres database export to SQL?

[imabev]

Is there any documentation available on the 3CX postgres database (database schema - whats in every table?). Is there any info on exporting postgres to SQL Server. I would like to get the database off of 3CX and in to SQL.

I am still on v11 so not sure if v12 has any additional capabilities for export.

 

[ian.watts]

While we have hacked the PostgreSQL for more call reporting (using SSRS of all things..), I don't believe you can make 3CX use MSSQL natively. I suppose you could try copying between DBMSs.. but unless you can hack some connection string in a .config or something, I doubt you'd get the system to use something else.

Then again, it may be possible.

Doubtful somebody has what you are looking for in this case, but you can peek around for what you might need. We were able to compare call reports in the app/web versus the data to map out the values we needed.