SqlInstallationHelper MembersKentico 8.1 API Reference
The SqlInstallationHelper type exposes the following members.
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(String, String, String)
Creates database.
Public methodStatic memberCreateDatabase(SQLServerAuthenticationModeEnum, String, String, String, String)
Creates database based on given info.
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 memberCheckIfSchemaExist
Check if DB schema exists.
Public methodStatic memberInstallDatabase
Performs the database installation.
Public methodStatic memberTestConnection
Test connection.
Back to Top
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
Back to Top
Events

  NameDescription
Public eventStatic memberAfterDataGet
Fired after data getting is finished.
Back to Top
See Also