We would like to move AD SelfService into our DMZ. We would like to ensure the DB is not housed on the same server as the web client application. Currently it was installed with the original Postgres DB and i'm not sure how to seperate the DB from the web server to a sepererate server. Ideally we would like to migrate the DB into MSSQL but from what i have read it looks like MSSQL is only an option for fresh installs and not migrations, but we would hate for all our users to loose their current enrollments and force them to re-enroll.
What are my options here?