4.8 Migrating the Database

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

  1. In the Configuration Utility, click Migrate Database.

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

  3. Click the browse button and locate the path that contains the SQLite database files.

    For example, C:\ProgramData\Novell\Storage Manager\Engine\data

  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 Storage Manager SQLite database to an existing Storage Manager SQL Server database that contains policies or other critical data. Doing so is not supported as it could result in unpredicatable 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.