How to migrate from SQL Compact to SQL Express Database for Defender Management portal? (4372817)

How to migrate from SQL Compact to SQL Express Database for Defender Management portal?

How to migrate from SQL Compact to SQL Express Database for Defender Management portal?

1. Install SQL Express Server on the server running Defender Management portal.


2. Edit the web.config file

The default location is:
%ProgramFiles%\One Identity\Defender\Management Portal\WWW\web.config

Change:
<add key="isCompactDatabase" value="true"/>

to:
<add key="isCompactDatabase" value="false"/>



3. Use the DBSwap.exe executable to migrate the database

%ProgramFiles%\One Identity\Defender\Management Portal\Tools\DBSwap.exe

Select the 'Switch to SQL Express' option and click on Submit.
 

Answer 'yes' to the warning if you are switching to SQL Express database for the first time.
 

Note: 
The data in the destination database will be overwritten after the migration. 
Hence it is recommended to use this option only while switching to SQL Express for the first time to avoid any data loss.

See the 'Configuring SQL Express Server as database for the portal' section in the Defender Administration guide for more details: https://support.oneidentity.com/technical-documents/defender/6.4/administration-guide/32#TOPIC-1955324