To set up the infrastructure in the Data Virtualization Module, do the following procedure:
https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371964152176980307/MS-SQL+Initial+Setup#Self-service-deployment-for-Native-SQL-Server
https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371964152176980307/MS-SQL+Initial+Setup#To-add-a-source-host
https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371964152176980307/MS-SQL+Initial+Setup#To-create-a-test-data-environment%3A
https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371964152176980307/MS-SQL+Initial+Setup#To-add-a-target-host%3A
https://accelario.atlassian.net/wiki/spaces/DVPD/pages/21371964152176980307/MS-SQL+Initial+Setup#To-add-a-DB-Home%3A
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:
Click the Self-service Deploy app on the taskbar.
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
You can set up additional test data environments. |
To add a source host
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:
On the navigation bar, click Source.
...
4. Enter a Name.
...
5. Click Next.
To create a test data environment from a LIVE GI:
Enter the test data environment details.
Select a storage type: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:
Enter the test data environment details.
Select a storage type:iSCSI
...
The Source Management window displays the test data environment for the source host that has been created.
To add a target host:
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 | ||||||
---|---|---|---|---|---|---|
| ||||||
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:
On the navigation bar, click VDB.
The VDB Management window appears.
...
To select a GI:
In the VDB Management window, select a Test Data Environment.
...
Select the GI.
...
Adding a snapshot:
Select the source.
Click Add Snapshot.
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
It is possible to scroll using the time and date to the right of a search screenshot. |
To create a VDB from a snapshot:
Select a snapshot.
Click Create VDB.
...
The following icons display information about a VDB:
Icon | Description |
VDB Locked |
VDB Stopped |
VDB Started |
VDB Creation Failed |