We currently have our SDP installed on a Windows Server 2008 (not R2) server using MSSQL Server on the same machine. I am looking at decommissioning this server and need to migrate the SDP installation to another server.

Is there any benefit to moving to PostgreSQL (if it is possible to change the database type) or should we stick with MSSQL Server? The new server does not have MSSQL Server installed on it, but we can use separate one if needed.

Is there a procedure for migrating the database from MSSQL to PostgreSQL?