public void Test_GetSqlSampleCopy_1()
{
sdt = new DGTDataTransfer(testServer, testDatabaseName, targetServer, targetDatabaseName);
String expected = "SELECT * FROM [Production].[Product] TABLESAMPLE(100 PERCENT);";
String actual = sdt.GetSqlSampleCopy(testTable, 100);
Assert.AreEqual(expected, actual);
}
public void Test_GetSqlTopNCopy_1()
{
sdt = new DGTDataTransfer(testServer, testDatabaseName, targetServer, targetDatabaseName);
String expected = "SELECT TOP 100 PERCENT * FROM [Production].[Product] ORDER BY NEWID();";
String actual = sdt.GetSqlTopNCopy(testTable, 100);
Assert.AreEqual(expected, actual);
}
public void Test_GetSqlCopyDataMissingKeys_1()
{
sdt = new DGTDataTransfer(testServer, testDatabaseName, targetServer, targetDatabaseName);
String expected = "";
String actual = sdt.GetSqlCopyDataMissingKeys(testTable.ForeignKeys[0]);
Assert.AreEqual(expected, actual);
}
