Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

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

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

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

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

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

  6. https://accelario.atlassian.net/wiki/spaces/DVPD/pages/2137196415/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:

  • Configure source host

  • Configure target host

  • Configure source database

  • Configure target database

  • Provision your first VDB

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.

The wizard automatically starts after the Self-service Deploy app is opened.

  1. Do all the steps in the procedure.

  1. Enter all the required parameters.

  1. Click Next to go to the VDB Management window.

You can cancel the wizard and return to it at another time.

You can set up additional test data environments.

To add a source host

  1. On the navigation bar, click Source.

The Source Management window appears.

2. Click Add Source Host.

3. Enter the source host details.

In all dialog boxes, an asterisk * next to a label on the left is used to identify a mandatory user input.

4. Click Add.

After the source host is added, the following message appears: Source Host has been added.

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.

The Source Management window appears.

2. Click Create Test Data Environment.

3. Select DB type.

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

For iSCSI storage type it is necessary in the Capacity field to enter the capacity in GB.

b. NFS

2. Click Next.

3. Enter the Source DB Parameters.

4. Click Create.

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

For iSCSI storage type it is necessary in the Capacity field to enter the capacity in GB.

b. NFS

2. Click Next.

3. Enter the Source DB Parameters.

It is recommended to select the Refresh Immediately checkbox to make a full copy of the Golden Image after the test data environment is automatically created.

4. Click Test Connection to verify that the connection to the database is valid.

After the test is complete, the following message appears: Test Data Environment connection is valid.

5. Click Done.

After the test data environment is created, the following message appears: Test Data Environment has been created.

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.

2. Click Add Target Host.

3. Enter the target host details.

4. Click Add.

After the target host is added, the following message appears: Target Host has been added.

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

To add a DB Home:

You add a DB Home in the Target work area.

  1. Click Add DB Home.

2. Select a DB type.

3. Enter the DB Home details.

4. Click Next to go to the next Add DB Home window.

5. To save your changes, click Add.

After the DB Home is added, the following message appears: DB Home has been added.

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.

  1. Enter a Name.

  1. Click Add.

After the snapshot is created, the following message appears: Snapshot has been created.

The Snapshots work area displays the new snapshot with all the snapshots that have been created.

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.

3. Enter the VDB parameters.

It is recommended to select the Start Immediately checkbox.

4. Enter the Advanced Parameters, if necessary.

5. Click Create VDB. Otherwise, click Cancel to exit without creating a VDB.

After the VDB is created, the following message appears: The volume has been created.

The VDB Management window displays the VDB that has been created.

The following icons display information about a VDB:

Icon

Description

VDB Locked

VDB Stopped

VDB Started

VDB Creation Failed

  • No labels