SQL Server is Microsoft’s relational database which is typically run on Windows Server hosts. With Delphix, you can use various SQL Server configurations, ranging from Failover Clusters to Availability Groups. In this section, you’ll find an overview of how Delphix works with SQL Server.
There are three key concepts when using Delphix with any data platform:
- Environments: The server and software required to run a data set.
- Source Environment: Source data to be ingested into Delphix. These will be used to create dSources.
- Target Environment: Target hosts to provision VDBs.
- dSources: A database that the Delphix Virtualization Engine uses to create and update virtual copies of your database
- VDBs: A database provisioned from either a dSource or another VDB which is a copy of the source data. A VDB is created and managed by the Delphix Virtualization Engine.
With these concepts in mind, let’s explore how Delphix connects to SQL Server environments and creates SQL Server dSources and VDBs.