public void PopulateData()
{
//Get last field pk
Azure azure = new Azure();
string queryAzure = "SELECT MAX() FROM " + RealTableName;
string maxID = azure.GetSingleValue(queryAzure);
//Get source data
//Delete temp tables in destination
}
public void PopulateData()
{
//Get last field PK
Azure azure = new Azure();
string queryAzure = "SELECT MAX(TransactionNumber) FROM " + RealTableName;
string maxID = azure.GetSingleValue(queryAzure);
//Get source data
Sanyo sanyo = new Sanyo();
string querySanyo = String.Format("SELECT * FROM {0} WHERE {1} > {2}", SourceName, UpdateIdentifier, maxID);
sanyo.PopulateData(ref SourceData, querySanyo);
//Delete temp tables in destination
azure.DeleteTempTable(DestinationTableName);
}
public void PopulateData()
{
//Get last field pk
Azure azure = new Azure();
string queryAzure = "SELECT MAX(PK) FROM " + RealTableName;
string maxID = azure.GetSingleValue(queryAzure);
//Get source data
Oracle oracle = new Oracle();
string queryOracle = String.Format("SELECT * FROM {0} WHERE {1} > {2}", SourceName, UpdateIdentifier, maxID);
oracle.PopulateData(ref SourceData, queryOracle);
//DELETE temp tables in destination
azure.DeleteTempTable(DestinationTableName);
}
public void PopulateData()
{
//Get last field PK
Azure azure = new Azure();
//string queryAzure = "SELECT MAX(CONVERT(varchar, GamingDate, 6)) FROM " + RealTableName;
string queryAzure = "SELECT MAX(GamingDate) FROM " + RealTableName;
string maxID = azure.GetSingleValue(queryAzure);
DateTime dateMax = Convert.ToDateTime(maxID);
//Get source data
Oracle oracle = new Oracle();
string queryOracle = String.Format("SELECT * FROM {0} WHERE {1} > '{2}'", SourceName, UpdateIdentifier, dateMax.ToString("dd/MMM/yy"));
oracle.PopulateData(ref SourceData, queryOracle);
//Delete temp tables in destination
azure.DeleteTempTable(DestinationTableName);
}