Table of Contents

Class SqlInstance

Namespace
CENTREL.XIA.Configuration.Types
Assembly
CENTREL.XIA.Configuration.Types.dll

Represents a Microsoft SQL server instance running on a machine or in Azure.

[SupportsClientScan]
[SupportsSupportProvisions]
public class SqlInstance : BaseConfigurationType
Inheritance
SqlInstance
Inherited Members

Constructors

SqlInstance()

Initializes a new instance of the CENTREL.XIA.Configuration.Types.SqlInstance class.

public SqlInstance()

Properties

Agent

Gets or sets the SQL server agent configuration for the SQL instance. This only applies to on-premises installations of SQL Server.

public SqlAgent Agent { get; set; }

Property Value

SqlAgent

AvailabilityGroups

Gets or sets the availability groups configured for the SQL instance. This only applies to on-premises installations of SQL Server 2012 and above.

public SqlAvailabilityGroups AvailabilityGroups { get; set; }

Property Value

SqlAvailabilityGroups

Databases

Gets or sets the databases on the SQL instance.

public SqlDatabases Databases { get; set; }

Property Value

SqlDatabases

Hosts

Gets or sets the host information for the SQL instance. This only applies to on-premises installations of SQL Server.

public SqlInstanceHostsInformation Hosts { get; set; }

Property Value

SqlInstanceHostsInformation

Management

Gets or sets the management configuration for a SQL instance. This only applies to on-premises installations of SQL Server.

public SqlManagement Management { get; set; }

Property Value

SqlManagement

Security

Gets or sets the security information for the SQL instance.

public SqlSecurity Security { get; set; }

Property Value

SqlSecurity

ServerObjects

Represents the server objects configured for a SQL instance. This only applies to on-premises installations of SQL Server.

public SqlServerObjects ServerObjects { get; set; }

Property Value

SqlServerObjects

ServerProperties

Gets or sets the server properties.

public SqlServerProperties ServerProperties { get; set; }

Property Value

SqlServerProperties

Methods

Clone()

Returns a CENTREL.XIA.Configuration.Types.SqlInstance cloned from this object.

public SqlInstance Clone()

Returns

SqlInstance

A CENTREL.XIA.Configuration.Types.SqlInstance.

FromXml(string)

Returns a CENTREL.XIA.Configuration.Types.SqlInstance class from the specified XML.

public static SqlInstance FromXml(string xml)

Parameters

xml string

The XML representation of the object.

Returns

SqlInstance

A CENTREL.XIA.Configuration.Types.SqlInstance class.

LoadXml(string)

Returns the SQL instance from the specified XML file.

public static SqlInstance LoadXml(string filePath)

Parameters

filePath string

The absolute path of the XML file to load.

Returns

SqlInstance

A CENTREL.XIA.Configuration.Types.SqlInstance from the specified XML.