Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To set up the infrastructure in the Data Virtualization Module, do the following procedure:

  1. https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371964152176980307/MS-SQL+Initial+Setup#Self-service-deployment-for-Native-SQL-Server

  2. https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371964152176980307/MS-SQL+Initial+Setup#To-add-a-source-host

  3. https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371964152176980307/MS-SQL+Initial+Setup#To-create-a-test-data-environment%3A

  4. https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371964152176980307/MS-SQL+Initial+Setup#To-add-a-target-host%3A

  5. https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371964152176980307/MS-SQL+Initial+Setup#To-add-a-DB-Home%3A

  6. https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371964152176980307/MS-SQL+Initial+Setup#To-create-and-start-a-VDB.

Self-service deployment for Native SQL Server

You can use a self-service deploy wizard to define your first Native SQL Server Backup golden image of a production database and to create your first VDB. The following operations can be done with the self-service deploy wizard:

...

With the self-service deploy wizard, you can configure the source and target Accelario agents, validate the host name and agent port, and automatically discover the source and target databases. The wizard will also deploy the Native SQL Server Backup Golden Image, load it with an initial set of data, provision the first VDB, and permit you to start to work immediately. This can be done without assistance from a third-party vendor or technical support team. Additionally, you can set up additional test data environments.

To deploy a Native SQL Server with the Self-service Deploy wizard:

  1. Click the Self-service Deploy app on the taskbar.

...

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#EAE6FF

You can set up additional test data environments.

To add a source host

  1. On the navigation bar, click Source.

...

The Source Management window displays the source host(s) that have been added to the system.

...

To create a test data environment:

  1. On the navigation bar, click Source.

...

4. Enter a Name.

...

5. Click Next.

To create a test data environment from a LIVE GI:

  1. Enter the test data environment details.
    Select a storage type:

    1. iSCSI

...

The Source Management window displays the test data environment for the source host that has been created.

...

To create a test data environment from a Native SQL server Backup:

  1. Enter the test data environment details.
    Select a storage type:

    1. iSCSI

...

The Source Management window displays the test data environment for the source host that has been created.

To add a target host:

  1. On the navigation bar, click Target.
    The Target Management window appears.

...

The Target Management displays the target host(s) that have been added to the system.

...

To add a DB Home:

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#EAE6FF

You add a DB Home in the Target work area.

...

The Target Management displays the DB Home(s) that have been added to the system.

...

To create and start a VDB.

To create a VDB:

  1. On the navigation bar, click VDB.
    The VDB Management window appears.

...

To select a GI:

  1. In the VDB Management window, select a Test Data Environment.

...

  1. Select the GI.

...

Adding a snapshot:

  1. Select the source.

  2. Click Add Snapshot.

...

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#EAE6FF

It is possible to scroll using the time and date to the right of a search screenshot.

To create a VDB from a snapshot:

  1. Select a snapshot.

  2. Click Create VDB.

...

The following icons display information about a VDB:

Icon

Description

Image Removed
Image Added

VDB Locked

Image Removed
Image Added

VDB Stopped

Image Removed
Image Added

VDB Started

Image Removed
Image Added

VDB Creation Failed