public void ValidRestore()
{
DbSnapshotMgr target = new DbSnapshotMgr();
DbConnectionInfo connectionInfo = new DbConnectionInfo(@".\", "SQL2012");
string databaseName = "Certit";
string snapshotDatabaseName = "Certit_120725";
target.RestoreSnapshot(connectionInfo, databaseName, snapshotDatabaseName);
}
public void SnapshotDbIsNotASnapshot()
{
DbSnapshotMgr target = new DbSnapshotMgr();
DbConnectionInfo connectionInfo = new DbConnectionInfo(@".\", "SQL2012");
string databaseName = "Certit";
string snapshotDatabaseName = "Certit";
try
{
target.RestoreSnapshot(connectionInfo, databaseName, snapshotDatabaseName);
Assert.Fail();
}
catch (ArgumentException ex)
{
Assert.IsTrue(ex.Message.Contains("is not a snapshot"));
}
}
public void InvalidDatabaseName()
{
DbSnapshotMgr target = new DbSnapshotMgr();
DbConnectionInfo connectionInfo = new DbConnectionInfo();
string databaseName = string.Empty;
string snapshotDatabaseName = string.Empty;
try
{
target.RestoreSnapshot(connectionInfo, databaseName, snapshotDatabaseName);
Assert.Fail();
}
catch (ArgumentNullException ex)
{
Assert.IsTrue(ex.Message.Contains("databaseName"));
}
}
public void InvalidSnapshot()
{
DbSnapshotMgr target = new DbSnapshotMgr();
DbConnectionInfo connectionInfo = new DbConnectionInfo(@".\", "SQL2012");
string databaseName = "Certit";
string snapshotDatabaseName = "UnknowSnapshotDb";
try
{
target.RestoreSnapshot(connectionInfo, databaseName, snapshotDatabaseName);
Assert.Fail();
}
catch (ArgumentOutOfRangeException ex)
{
Assert.IsTrue(ex.Message.Contains("does not exists"));
}
}
public string Restore(string server, string instance, string database, string snapshot, string username = "", string password="")
{
DbSnapshotMgr mgr = new DbSnapshotMgr();
DbConnectionInfo connectionInfo;
if (!string.IsNullOrWhiteSpace(username) && !string.IsNullOrWhiteSpace(password))
{
connectionInfo = new DbConnectionInfo(server, instance, username, password);
}
else
{
connectionInfo = new DbConnectionInfo(server, instance);
}
try
{
mgr.RestoreSnapshot(connectionInfo,database,snapshot);
}
catch (Exception ex)
{
return ex.ToString();
}
return "Ok";
}
