public void BackupNorthwind() { SqlAdministrator admin = new SqlAdministrator(connectionString, "Northwind"); Assert.IsTrue(admin.ContainsDatabase()); admin.BackupDatabase(DbBackupDevice.Disk, @"c:\Backups\Northwind.bsql"); }
public void BackupRestore() { this.admin = new SqlAdministrator(connectionString, "BackupRestoreTest"); admin.CreateDatabase(); Assert.IsTrue(admin.ContainsDatabase()); admin.BackupDatabase(DbBackupDevice.Disk, @"c:\Backups\BackupRestoreTest.bsql"); admin.DropDatabase(); Assert.IsFalse(admin.ContainsDatabase()); admin.RestoreDatabase(DbBackupDevice.Disk, @"c:\Backups\BackupRestoreTest.bsql"); Assert.IsTrue(admin.ContainsDatabase()); admin.DropDatabase(); Assert.IsFalse(admin.ContainsDatabase()); }
public void BackupRestore() { this.admin = new SqlAdministrator(connectionString, "BackupRestoreTest"); admin.CreateDatabase(); Assert.IsTrue(admin.ContainsDatabase()); admin.BackupDatabase(DbBackupDevice.Disk, @"c:\Backups\BackupRestoreTest.bsql"); admin.DropDatabase(); Assert.IsFalse(admin.ContainsDatabase()); admin.RestoreDatabase(DbBackupDevice.Disk, @"c:\Backups\BackupRestoreTest.bsql"); Assert.IsTrue(admin.ContainsDatabase()); admin.DropDatabase(); Assert.IsFalse(admin.ContainsDatabase()); }
public void BackupNorthwind() { SqlAdministrator admin = new SqlAdministrator(connectionString, "Northwind"); Assert.IsTrue(admin.ContainsDatabase()); admin.BackupDatabase(DbBackupDevice.Disk, @"c:\Backups\Northwind.bsql"); }