Info on postgres database export to SQL?

Discussion in '3CX Phone System - General' started by imabev, Oct 22, 2013.

Thread Status:
Not open for further replies.
  1. imabev

    Joined:
    Aug 17, 2012
    Messages:
    56
    Likes Received:
    0
    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.
     
  2. ian.watts

    ian.watts Active Member

    Joined:
    Apr 8, 2011
    Messages:
    532
    Likes Received:
    1
    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.
     
Thread Status:
Not open for further replies.