SqlInstallationHelper Members

Kentico 8.1 API Reference

The SqlInstallationHelper type exposes the following members.

Methods

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

Fields

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

Events

	Name	Description
	AfterDataGet	Fired after data getting is finished.