public void PopulateData()
{
Oracle oracle = new Oracle();
string queryOracle = "SELECT * FROM " + SourceName;
oracle.PopulateData(ref SourceData, queryOracle);
Azure azure = new Azure();
azure.DeleteTempTable(DestinationTableName);
}
public void PopulateData()
{
Oracle oracle = new Oracle();
string queryOracle = "SELECT * FROM " + SourceName + " WHERE CREATEDDATE >= SYSDATE OR MODIFIEDDATE >= SYSDATE";
oracle.PopulateData(ref SourceData, queryOracle);
//Delete temp tables in destination
Azure azure = new Azure();
azure.DeleteTempTable(DestinationTableName);
}
public void PopulateData()
{
//Get all details, process in azure
Oracle oracle = new Oracle();
string query = "SELECT * FROM " + SourceName;
oracle.PopulateData(ref SourceData, query);
//Delete temp table in destination
Azure azure = new Azure();
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);
}