SqlInstallationHelper Class

Sets of methods for creating database during installation process.

Inheritance Hierarchy

System.Object
  CMS.DataEngine.SqlInstallationHelper

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 10.0.0

Syntax

public static class SqlInstallationHelper

The SqlInstallationHelper type exposes the following members.

Fields

	Name	Description
Public field Static member	DB_CONNECTION_TIMEOUT	Default SQL connection timeout.
Public field Static member	DBO_SCHEMA	DB Owner schema
Public field Static member	RunQuery	Executes when SQL script is run by the installer

Methods

	Name	Description
Public method Static member	BackupDatabase	Backup given database to filesystem.
Public method Static member	CopyDatabase	Create a copy of database. This feature is available only in SQL Azure databases.
Public method Static member	CopyingCompleted	Checks if given database is being copied.
Public method Static member	CreateDatabase	Creates database.
Public method Static member	DatabaseExists	Returns true if database exists.
Public method Static member	DatabaseIsSeparated	Checks if database is separated or not.
Public method Static member	DeleteDatabase	Deletes database.
Public method Static member	EnsureDefaultSchema	Ensures the default schema for current user
Public method Static member	GetConnectionString	Returns connection string for the given parameters.
Public method Static member	GetCurrentDefaultSchema(String)	Returns current default schema
Public method Static member	GetCurrentDefaultSchema(IDataConnection)	Returns current default schema
Public method Static member	GetDatabaseVersion	Returns database version from settings key.
Public method Static member	GetDefaultBackupPath	Retrieves SQL server default backup directory from it's registry.
Public method Static member	GetEngineEdition	Returns database engine edition of the instance of SQL Server installed on the server.
Public method Static member	GetSQLInstallPath	Gets the folder in which the SQL install scripts are located.
Public method Static member	GetSQLInstallPathToObjects	Gets the folder in which the SQL install scripts for DB objects are located.
Public method Static member	GetUniqueDatabaseName	Returns unique database name.
Public method Static member	ChangeDefaultSchema	Changes the database schema to the given schema
Public method Static member	CheckAllConstraints	Performs (re)check operation of all constraints for specified table. If operation finish successfully untrusted constraints will be trusted.
Public method Static member	CheckIfSchemaExist	Check if DB schema exists.
Public method Static member	InstallDatabase	Performs the database installation.
Public method Static member	TestConnection	Test connection.

Events

	Name	Description
Public event Static member	AfterDataGet	Fired after data getting is finished.