public void CanScriptOutAlevinDatabase()
{
try
{
var testSubject = new DatabaseBackupViaSqlFileCreator(DatabaseServer, "AlevinDB");
// Act
// ---
string sqlBackup = testSubject.CreateSqlBackup();
// Assert
// ------
Approvals.Verify(sqlBackup);
}
finally
{
}
}
public void CanScriptOutDatabase()
{
// Arrange
// -------
using (var initialConn = new SqlConnection(string.Format("Server={0};Database={1};Trusted_Connection=True;pooling=false", DatabaseServer, DefaultStartDatabase)))
{
initialConn.Open();
CleanupDatabase(initialConn);
SetupTestDatabase(initialConn);
initialConn.Close();
}
try
{
var testSubject = new DatabaseBackupViaSqlFileCreator(DatabaseServer, _testDatabaseName);
// Act
// ---
string sqlBackup = testSubject.CreateSqlBackup();
// Assert
// ------
Approvals.Verify(sqlBackup);
}
finally
{
using (var secondConn = new SqlConnection(string.Format("Server={0};Database={1};Trusted_Connection=True;pooling=false", DatabaseServer, DefaultStartDatabase)))
{
secondConn.Open();
// Clean up
// ---------
CleanupDatabase(secondConn);
secondConn.Close();
}
}
}