Click or drag to resize
SqlInstallationHelper Class
Sets of methods for creating database during installation process.
Inheritance Hierarchy
SystemObject
  CMS.DataEngineSqlInstallationHelper

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 10.0.0
Syntax
C#
public static class SqlInstallationHelper

The SqlInstallationHelper type exposes the following members.

Fields
  NameDescription
Public fieldStatic memberDB_CONNECTION_TIMEOUT
Default SQL connection timeout.
Public fieldStatic memberDBO_SCHEMA
DB Owner schema
Public fieldStatic memberRunQuery
Executes when SQL script is run by the installer
Top
Methods
  NameDescription
Public methodStatic memberBackupDatabase
Backup given database to filesystem.
Public methodStatic memberCopyDatabase
Create a copy of database. This feature is available only in SQL Azure databases.
Public methodStatic memberCopyingCompleted
Checks if given database is being copied.
Public methodStatic memberCreateDatabase
Creates database.
Public methodStatic memberDatabaseExists
Returns true if database exists.
Public methodStatic memberDatabaseIsSeparated
Checks if database is separated or not.
Public methodStatic memberDeleteDatabase
Deletes database.
Public methodStatic memberEnsureDefaultSchema
Ensures the default schema for current user
Public methodStatic memberGetConnectionString
Returns connection string for the given parameters.
Public methodStatic memberGetCurrentDefaultSchema(String)
Returns current default schema
Public methodStatic memberGetCurrentDefaultSchema(IDataConnection)
Returns current default schema
Public methodStatic memberGetDatabaseVersion
Returns database version from settings key.
Public methodStatic memberGetDefaultBackupPath
Retrieves SQL server default backup directory from it's registry.
Public methodStatic memberGetEngineEdition
Returns database engine edition of the instance of SQL Server installed on the server.
Public methodStatic memberGetSQLInstallPath
Gets the folder in which the SQL install scripts are located.
Public methodStatic memberGetSQLInstallPathToObjects
Gets the folder in which the SQL install scripts for DB objects are located.
Public methodStatic memberGetUniqueDatabaseName
Returns unique database name.
Public methodStatic memberChangeDefaultSchema
Changes the database schema to the given schema
Public methodStatic memberCheckAllConstraints
Performs (re)check operation of all constraints for specified table. If operation finish successfully untrusted constraints will be trusted.
Public methodStatic memberCheckIfSchemaExist
Check if DB schema exists.
Public methodStatic memberInstallDatabase
Performs the database installation.
Public methodStatic memberTestConnection
Test connection.
Top
Events
  NameDescription
Public eventStatic memberAfterDataGet
Fired after data getting is finished.
Top
See Also