Retour
-
Titre
How to migrate from SQL Compact to SQL Express Database for Defender Management portal? -
Description
How to migrate from SQL Compact to SQL Express Database for Defender Management portal?
-
Résolution
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. -
Informations supplémentaires
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