| Table of Contents |
|---|
General
A source host is a server that hosts the source databases. A test data environment includes access definition to one source database and a GI. This section describes how to create and manage a Source Host and a Test Data Environment.
A Golden Image (GI) refers to a pre-configured template of a database environment. This template encapsulates a snapshot of the database including its schema, data, configurations, and associated applications. It serves as a master copy from which multiple instances of the database can be rapidly deployed, ensuring consistency, reliability, and quick scalability across different virtual environments.
Supported types of Golden Images for MSSQL database
Each type of Golden Image for MSSQL databases serves a specific set of needs, from real-time replication to disaster recovery and cloud-based management. The choice of GI should align with the operational objectives and the specific environment, whether it’s on-premises or cloud-based like AWS RDS.
1. Live Golden Image (Live GI)
A Live GI for SQL Server is a real-time, operational replica of a production database. It includes all current data, configurations, and running state of the database. Suitable for immediate replication needs, creating test environments that mirror the production state
2. Native SQL Server Backup
This type of Golden Image is created using SQL Server’s native backup functionality. It consists of full, differential, or transaction log backups, capturing the database at a specific point in time. Ideal for point-in-time recovery, it enables the restoration of the database to a specific historical state.
3. AWS RDS MSSQL Golden Image
Specifically designed for SQL Server databases running on Amazon RDS, this Golden Image type incorporates the functionalities of SQL Server with optimizations for the AWS cloud infrastructure.
Storage Protocol configuration
Storage option
This parameter determines the type of storage protocol used for the database environment. The available options are iSCSI (Internet Small Computer System Interface) and NFS (Network File System).
Capacity (GB)
This parameter specifies the storage capacity allocated to the MSSQL Server database environment, measured in gigabytes (GB). The capacity should be chosen based on the size of your database and expected growth. Ensure enough space not only for the current database size but also for future data, backups, logs, and additional overhead.
User and Password
These optional parameters are part of the security credentials required for accessing the storage.
The username utilized for authentication to the storage system and the corresponding password for the provided username.
To open the Source work area:
...
To modify a source host:
Select the source host.
Click Modify source host.
Modify the source host as required.
...
The VDB Management window displays the GI that was created.
...
To modify a Live GI:
Modify the Golden Image Parameters as required.
...
Click Next to go to the next Modify Test Data Environment window.
Modify the Source DB Parameters as required.
...
To save your changes, click Modify.
SQL Native Server Backup
To create a SQL Native Server Backup:
...
The VDB Management window displays the GI that was created.
...
To modify a native SQL Server Backup:
Modify the Golden Image Parameters as required.
...
2. Click Next to go to the next Modify Test Data Environment window.
3. Modify the Source DB Parameters as required.
...
To save your changes, click Modify.
RDS AWS SQL
To create or modify RDS AWS SQL GI:
Create GI.
...
Create or modify Test data environment.
...
...
Provide AWS parameters
...
Test Data Environment
To create a test data environment:
...
The Modify Test Data Environment window appears. Modify the test data environment name if necessary.
...
...
Click Next to go to the next Modify Test Data Environment window.
To
...
Modify the Golden Image Parameters as required.
...
2. Click Next to go to the next Modify Test Data Environment window.
3. Modify the Source DB Parameters as required.
...
4. To save your changes, click Modify.
To modify a native SQL Server Backup:
Modify the Golden Image Parameters as required.
...
2. Click Next to go to the next Modify Test Data Environment window.
3. Modify the Source DB Parameters as required.
...
To save your changes, click Modify.
...
see information about a test data environment:
Select the test data environment.
Click Test Data Environment Info.
...