SQL Server virtualization process
Overview
The virtualization process is an excerpt and provides various tasks that are required to complete Oracle data virtualization and how to work with SQL Server database objects in the Delphix Engine. It does not cover advanced configuration options including SQL Server failover cluster or best practices for performance.
The following material introduces you to the overall process of deploying the SQL Server data virtualization solution. A sequence of high-level steps is presented; each step briefly describes the task and the expected result. Refer to the embedded links for more detailed information.
Begin by reviewing the general Delphix Continuous Data Engine architecture diagrams Identify existing or new SQL Server data source and target Environments, the underlying Operating Systems, and SQL Server data source versions. This will give a good understanding of the architectural strategy and confirm support.
Review the SQL Server Support Matrix Confirm that your combination of SQL Server software, host operating system, Delphix Engine version, and SQL Server connector version are supported for the various environments that will integrate into your SQL Server data source deployment. Early validation will reduce unexpected issues later.
Deploy and configure the Delphix Continuous Data Engine.
Prepare source and create target environments Prepare the source, create the target hosts, and ensure they are running and reachable. Follow the host requirements to configure the respective environments. The source environment is the SQL Server database that the Delphix Continuous Data Engine will ingest from. The target environment will host one or more SQL Server instance(s) in which the virtual database copies will be created.
Consult the source environment and target environment requirements documentation for configuration details.
Add source and target environments in the Delphix Continuous Data engine Use the "Add Environment" operation in Delphix Continuous Data Engine for each host, which causes Delphix to register the specific host and discover the Oracle database software installation(s) on that host.
Link the SQL Server source database Configure and create a dSource which allows the Delphix Continuous Data Engine to capture a copy of the source data. There are many ingestion methods that can offer a variety of methods to capture the data to be virtualized by Delphix. Therefore, we encourage you to identify the ingestion method that best suits your organization and infrastructure policies.
Provision virtual SQL Server databases Administrators and users can provision multiple copies of the source data as virtual databases.