Click or drag to resize
SqlInstallationHelper Methods

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
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
See Also