Database Migration

Besides of the native database migration possibilities with common tools like the MS SQL Import Export Wizard or the MS SQL Management Studio you can also use SpaceObServer in order to migrate your scans to another database.

Note: Your scans must be stored in the same database. You can ensure this by opening the “Scan > Configure Scans” dialog and checking the “Database” field in the “Expert Settings” tab.

Universal steps migrating the SpaceObServer database

Apart from the actual migration of the database the process is simple:

  1. Make sure that no scan is running or indexing is in progress.

  2. Stop the scan service and DataCentral service (under “Home” > “Options” > “Service/Index Service”) to make sure no operations are performed on the database.

  3. Migrate the database to the new machine.

  4. Connect SpaceObServer to the new machine.

  5. Restart the scan service and the DataCentral service.

If your scans are not stored in different databases, you can migrate your scans to another database by following the steps below:

Migration via SpaceObServer

  1. Open “Scan > Configure Scans”

  2. Select all the scans which you want to migrate. Note: Please only select the scans themselves but no containers (if existing).

  3. Right click and choose “Export > Export to SQL Server”.

  4. Select the new database type (e.g. MS SQL Server) and type in the server name of the new database server.

  5. Choose an existing database or create a new one by using the button on the right.

  6. Type in your database login information below. Optionally test the connection to the database by using the “Test Connection” button.

  7. Use the “Export” button in order to migrate the selected scans to the new database.

  8. After the copy operation has finished, close the “Configure Scans” dialog and go to “Tools > Options > Database” in order to switch to the new database.

  9. Confirm with “OK”.

MS SQL Import Export Wizard

You can migrate your SpaceObServer database by moving it to another database server via the MS SQL Import Export Wizard: https://msdn.microsoft.com/en-us/library/ms140052.aspx

MS SQL Management Studio

You can migrate your SpaceObServer scan database by simply detaching the database on the old server and attaching it to the new one:

Detach database: https://msdn.microsoft.com/en-us/library/ms191491.aspx

Attach database: https://msdn.microsoft.com/en-us/library/ms190209.aspx