To export files from a One Identity Manager database
-
Start the Launchpad and log in to the One Identity Manager database.
-
In the Change & Extend view, select the Import files for software update entry and click Start.
This starts the Software Loader program.
-
On the home page, select Export from database.
-
On the Connect to database page, check the One Identity Manager database connection data and change if necessary.
-
Specify which data to export on the Select files page.
-
Specify the destination directory to export the file to.
The Files tab displays the exported files with their status and file size.
Table 50: Meaning of the status
|
Unknown file |
The file is not yet exported from the database to the given directory. |
|
Version OK |
The file version matches the version in the database. |
|
Version modified |
The file version has changed with respect to the version in the database. |
-
Mark the files to export.
-
To export all the file of a machine role, select the machine role on the Machine role tab.
-
To select single files, select the files on the Files tab.
-
The marked files are export to the given directory. This may take some time depending on the number of files selected. The export steps are displayed on the page Uploading files. Any export errors are displayed. After exporting is complete, click Next.
-
To end the program, click Finish on the last page.
Related topics
To create a test or development database from a database backup from another system
-
Create a new database on the database server in the reference environment.
-
Create a database backup of the original database.
-
Restore the backup to the reference database.
-
Restore permissions for the database user on the database server.
-
Compile the database with the Database Compiler.
Use the Database Compiler to customize connection data for the database and compile all the scripts and processes in the database.
-
Start the Launchpad and log in to the One Identity Manager database.
-
In the Change & Extend pane, select the Compile database item.
This starts the .
-
On the Database Compiler start page, click Next.
-
On the Connect to database page, enter the connection data for the One Identity Manager database.
-
This verifies the database ID. If, during the verification, it transpires that the database ID is incorrect, you will be prompted to create a new ID. Confirm this prompt with OK. The database ID is changed.
-
On the Database connection information insufficient page, check the database connection data and change if necessary.
-
This test the database connection. Confirm the prompt with OK.
-
Enter the valid connection data for the One Identity Manager database.
-
On the Connect to database page, enter the connection data for the One Identity Manager database.
-
The components to be compiled are displayed on the Compilation settings page. To start compiling, click Next.
This starts the compilation process. The process may take some time.
-
The results of the compilation process are shown on the Compilation page. Click Next after compilation is complete.
-
Click Finish on the last page to end the program.
-
In the Designer, adjust the database staging level of the database.
-
In the Designer, select the Base Data > General > Databases category.
-
Select the database and change the value of the Staging level property to Test environment or Development system.
-
Select the Database > Save to database and click Save.
-
Customize the synchronization project's connection data in the Synchronization Editor.
After extending the server hardware for the SQL Server, the DBQueue Processor must be initialized again.
To initialize the DBQueue Processor manually
-
Wait until all DBQueue Processor tasks have completed. You can do this using the .
-
Start a suitable program for running SQL queries and perform the following steps one by one.
IMPORTANT: Select a user that you use for migrating the database to run the SQL queries.
-
Check whether other database sessions are active.
select *
from sys.sysprocesses p
where dbid = DB_ID()
and spid <> @@SPID
If there are still sessions active, they must be closed first.
-
Stop all DBQueue Processor components.
exec QBM_PWatchDogPrepare 1
go
exec QBM_PDBQueuePrepare 1
go
-
Initializing the DBQueue Processor.
exec QBM_PDBQueuePrepare 0,1
go
exec QBM_PWatchDogPrepare
go
For more information about using the DBQueue Processor, see the One Identity Manager Configuration Guide.
You can use various command line programs for the automation of One Identity Manager implementations.
Detailed information about this topic
