4.8 Migrating the Database

This procedure migrates the contents of the Novell Storage Manager 3.1.1 SQLite database to the Novell Storage Manager 4.1 SQL Server database. These contents include policies, schedules, pending events, etc.

  1. Click Migrate Database.

  2. From the wizard page, read the overview of the migration process and click Next.

  3. Verify that the Source Folder field displays the following path: C:\ProgramData\Novell\Storage Manager\Engine\data

    If the path is not displayed, click the browse button to specify the path.

  4. Click Next.

    If there are any events in cache (and therefore not yet pending events), the events are displayed.

    The Remove all records from the target SQL Server database before continuing option lets you remove any existing records in the target database instance before migrating. If there are any existing records in the SQL Server database instance, you should select this option to maintain the integrity of the database contents that are being migrated. This is applicable even if you decide to migrate the SQLite database again.

    It is not safe to migrate a Novell Storage Manager SQLite database to a SQL Server database that contains policies or other critical data. Doing so is not supported as it could result in unpredictable behavior with the database.

  5. Specify whether to remove any existing records in the target database and click Next.

  6. When notified that the migration has completed, click Finish.