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 CreateAndDropDatabase()
{
this.admin = new SqlAdministrator(connectionString, databaseName);
admin.CreateDatabase();
Assert.IsTrue(admin.ContainsDatabase());
admin.DropDatabase();
Assert.IsFalse(admin.ContainsDatabase());
admin.CreateDatabase();
string leftTable = "LEFT";
string createTable = String.Format(
"CREATE TABLE [{0}].[{1}] ( ID int PRIMARY KEY )"
, admin.DatabaseOwner
, leftTable
);
admin.ExecuteNonQuery(admin.DatabaseConnectionString,
createTable
);
string rightTable = "RIGHT";
createTable = String.Format(
"CREATE TABLE [{0}].[{1}] ( ID int PRIMARY KEY, LEFTID int REFERENCES [{0}].[{2}] )"
, admin.DatabaseOwner
, rightTable
, leftTable
);
admin.ExecuteNonQuery(admin.DatabaseConnectionString,
createTable
);
Assert.IsTrue(admin.ContainsTable(leftTable));
Assert.IsTrue(admin.ContainsTable(rightTable));
admin.DropConstraints(leftTable);
admin.DropTable(leftTable);
admin.DropConstraints(rightTable);
admin.DropTable(rightTable);
Assert.IsFalse(admin.ContainsTable(leftTable));
Assert.IsFalse(admin.ContainsTable(rightTable));
string tableName= "MYTABLE";
admin.DropTable(tableName);
admin.ExecuteNonQuery(
admin.DatabaseConnectionString
,"CREATE TABLE [{0}].[{1}] ( ID int )"
,admin.DatabaseOwner
,tableName
);
Assert.IsTrue(admin.ContainsTable(tableName));
admin.DropTable(tableName);
Assert.IsFalse(admin.ContainsTable(tableName));
admin.DropTable(tableName);
Assert.IsFalse(admin.ContainsTable(tableName));
tableName = "UNIQUETABLE";
createTable = String.Format(
"CREATE TABLE [{0}].[{1}] ( ID int PRIMARY KEY )"
, admin.DatabaseOwner
, tableName
);
admin.ExecuteNonQuery(admin.DatabaseConnectionString,
createTable
);
Assert.IsTrue(admin.ContainsTable(tableName));
admin.DropConstraints(tableName);
admin.DropTable(tableName);
Assert.IsFalse(admin.ContainsTable(tableName));
admin.DropDatabase();
admin.CreateDatabase();
Assert.IsTrue(admin.ContainsDatabase());
tableName = "MYTABLE";
admin.ExecuteNonQuery(
admin.DatabaseConnectionString,
"CREATE TABLE [{0}].[{1}] ( ID int )"
,admin.DatabaseOwner
,tableName
);
admin.DropDatabase();
Assert.IsFalse(admin.ContainsDatabase());
}
public void CreateAndDropDatabase()
{
this.admin = new SqlAdministrator(connectionString, databaseName);
admin.CreateDatabase();
Assert.IsTrue(admin.ContainsDatabase());
admin.DropDatabase();
Assert.IsFalse(admin.ContainsDatabase());
admin.CreateDatabase();
string leftTable = "LEFT";
string createTable = String.Format(
"CREATE TABLE [{0}].[{1}] ( ID int PRIMARY KEY )"
, admin.DatabaseOwner
, leftTable
);
admin.ExecuteNonQuery(admin.DatabaseConnectionString,
createTable
);
string rightTable = "RIGHT";
createTable = String.Format(
"CREATE TABLE [{0}].[{1}] ( ID int PRIMARY KEY, LEFTID int REFERENCES [{0}].[{2}] )"
, admin.DatabaseOwner
, rightTable
, leftTable
);
admin.ExecuteNonQuery(admin.DatabaseConnectionString,
createTable
);
Assert.IsTrue(admin.ContainsTable(leftTable));
Assert.IsTrue(admin.ContainsTable(rightTable));
admin.DropConstraints(leftTable);
admin.DropTable(leftTable);
admin.DropConstraints(rightTable);
admin.DropTable(rightTable);
Assert.IsFalse(admin.ContainsTable(leftTable));
Assert.IsFalse(admin.ContainsTable(rightTable));
string tableName = "MYTABLE";
admin.DropTable(tableName);
admin.ExecuteNonQuery(
admin.DatabaseConnectionString
, "CREATE TABLE [{0}].[{1}] ( ID int )"
, admin.DatabaseOwner
, tableName
);
Assert.IsTrue(admin.ContainsTable(tableName));
admin.DropTable(tableName);
Assert.IsFalse(admin.ContainsTable(tableName));
admin.DropTable(tableName);
Assert.IsFalse(admin.ContainsTable(tableName));
tableName = "UNIQUETABLE";
createTable = String.Format(
"CREATE TABLE [{0}].[{1}] ( ID int PRIMARY KEY )"
, admin.DatabaseOwner
, tableName
);
admin.ExecuteNonQuery(admin.DatabaseConnectionString,
createTable
);
Assert.IsTrue(admin.ContainsTable(tableName));
admin.DropConstraints(tableName);
admin.DropTable(tableName);
Assert.IsFalse(admin.ContainsTable(tableName));
admin.DropDatabase();
admin.CreateDatabase();
Assert.IsTrue(admin.ContainsDatabase());
tableName = "MYTABLE";
admin.ExecuteNonQuery(
admin.DatabaseConnectionString,
"CREATE TABLE [{0}].[{1}] ( ID int )"
, admin.DatabaseOwner
, tableName
);
admin.DropDatabase();
Assert.IsFalse(admin.ContainsDatabase());
}