internal static void Execute(ICakeContext context, string connectionString, string databaseName, BackupDatabaseSettings settings)
{
Guard.ArgumentIsNotNull(context, nameof(context));
Guard.ArgumentIsNotNull(connectionString, nameof(connectionString));
Guard.ArgumentIsNotNull(settings, nameof(settings));
var backupFile = GetBackupFileName(databaseName, settings.Path);
var compress = settings.Compress ? ", COMPRESSION" : string.Empty;
using (var connection = SqlServerAliasesImpl.OpenSqlConnection(context, connectionString))
{
context.Log.Information($"Backing up database '{databaseName}' to {backupFile}");
var sql = $@"
BACKUP DATABASE {Sql.EscapeName(databaseName)}
TO DISK = @backupFile
WITH FORMAT, INIT, COPY_ONLY, NAME = '{databaseName} Full Backup',
SKIP, REWIND, NOUNLOAD, STATS = 10 {compress}";
context.Log.Information(sql);
var command = SqlServerAliasesImpl.CreateSqlCommand(sql, connection);
command.Parameters.AddWithValue("@backupFile", backupFile);
command.ExecuteNonQuery();
}
}
public static void BackupDatabase(this ICakeContext context, string connectionString, string databaseName, BackupDatabaseSettings settings)
{
BackupDatabaseImpl.Execute(context, connectionString, databaseName, settings);
}