SqlServer aliases

Cake.SqlServer addin

Contains functionality to deal with DAC functionality from SQL Server: create and restore BACPAC files; create and restore DACPAC files

General

BackupDatabase(string, string, BackupDatabaseSettings)
Alias from Cake.SqlServer addin 		Backup an existing database to a file.
CreateBacpacFile(string, string, FilePath)
Alias from Cake.SqlServer addin 		Creates a bacpac file for easy database backuping.
CreateDatabase(string, string)
Alias from Cake.SqlServer addin 		Creates an empty database. If database with this name already exists, throws a SqlException. Cake.SqlServer.SqlServerAliases.CreateDatabaseIfNotExists(Cake.Core.ICakeContext,System.String,System.String) if you would like to check if database already exists.
CreateDatabase(string, string, CreateDatabaseSettings)
Alias from Cake.SqlServer addin 		Creates an empty database. If database with this name already exists, throws a SqlException. Allows to specify primary and log files location.
CreateDatabaseIfNotExists(string, string)
Alias from Cake.SqlServer addin 		Creates an empty database if another database with the same does not already exist.
CreateDatabaseIfNotExists(string, string, CreateDatabaseSettings)
Alias from Cake.SqlServer addin 		Creates an empty database if another database with the same does not already exist.
DatabaseExists(string, string)
Alias from Cake.SqlServer addin 		Test if the database exists
DropAndCreateDatabase(string, string)
Alias from Cake.SqlServer addin 		First drops, then recreates the database
DropAndCreateDatabase(string, string, CreateDatabaseSettings)
Alias from Cake.SqlServer addin 		First drops, then recreates the database
DropDatabase(string, string)
Alias from Cake.SqlServer addin 		Drops database. Before dropping the DB, database is set to be offline, then online again. This is to be sure that there are no live connections, otherwise the script will fail. Also if the database does not exist - it will not do anything.
ExecuteSqlCommand(SqlConnection, string)
Alias from Cake.SqlServer addin 		Execute any SQL command.
ExecuteSqlCommand(string, string)
Alias from Cake.SqlServer addin 		Execute any SQL command.
ExecuteSqlFile(SqlConnection, FilePath)
Alias from Cake.SqlServer addin 		Reads SQL commands from a file and executes them.
ExecuteSqlFile(string, FilePath)
Alias from Cake.SqlServer addin 		Reads SQL commands from a file and executes them.
ExtractDacpacFile(string, string, ExtractDacpacSettings)
Alias from Cake.SqlServer addin 		Extracts a dacpac file to a database package.
LocalDbCreateInstance(string)
Alias from Cake.SqlServer addin 		Creates a server instance and starts the server. The version number defaults to the version of the SqlLocalDB utility
LocalDbCreateInstance(string, LocalDbVersion)
Alias from Cake.SqlServer addin 		Creates a server instance and starts the server.
LocalDbDeleteInstance(string)
Alias from Cake.SqlServer addin 		Deletes the LocalDB instance
LocalDbStartInstance(string)
Alias from Cake.SqlServer addin 		Starts the LocalDB instance. Instance must exist before you can start it.
LocalDbStopInstance(string)
Alias from Cake.SqlServer addin 		Stops the LocalDB instance.
OpenSqlConnection(string)
Alias from Cake.SqlServer addin 		Opens a new Microsoft.Data.SqlClient.SqlConnection with the given connection string.
PublishDacpacFile(string, string, FilePath, PublishDacpacSettings)
Alias from Cake.SqlServer addin 		Publish a dacpac file to a database.
RestoreBacpac(string, string, FilePath)
Alias from Cake.SqlServer addin 		Restores a bacpac file into a database.

NB: there must be no database with the name you provide. Otherwise exception will be thrown.

RestoreMultipleSqlBackup(string, RestoreSqlBackupSettings, IList<FilePath>, IList<FilePath>)
Alias from Cake.SqlServer addin 		Restores a database from multiple backup files.
RestoreSqlBackup(string, FilePath)
Alias from Cake.SqlServer addin 		Restores a database from a backup file.
RestoreSqlBackup(string, FilePath, RestoreSqlBackupSettings)
Alias from Cake.SqlServer addin 		Restores a database from a backup file.
SetSqlCommandTimeout(int)
Alias from Cake.SqlServer addin 		Sets the CommandTimeout property for all SqlCommands used internally