private static void ConvertToSQLite()
{
SqlServerToSQLiteConverter sqlConv = new SqlServerToSQLiteConverter(Settings.TablesToLoad);
using (SQLiteConnection sqliteConn = sqlConv.InitializeSQLiteConnection(Settings.SQLiteConnectionString))
{
sqlConv.InitializeSQLiteDatabase(sqliteConn, Settings.PragmaParameters);
bool loadSuccess = false;
SqlConversionHandler sqlConversionHandler = new SqlConversionHandler(
delegate(bool done, bool success, int percent, string msg)
{
if (done)
{
if (success)
{
// log success
//Logging.Log(LogLevel.Debug, string.Format("SQLite DB load succeeded: {0}", msg));
loadSuccess = true;
}
else
{
// log failure
//Logging.Log(LogLevel.Error, string.Format("SQLite DB load failed: {0}", msg));
loadSuccess = false;
}
}
});
sqlConv.ConvertToDatabase(Settings.SQLConnectionString, sqliteConn, sqlConversionHandler, null, null, false);
sqliteConn.Close();
Console.WriteLine(loadSuccess);
}
}
private static void ConvertToSQLite()
{
SqlServerToSQLiteConverter sqlConv = new SqlServerToSQLiteConverter(Settings.TablesToLoad);
using (SQLiteConnection sqliteConn = sqlConv.InitializeSQLiteConnection(Settings.SQLiteConnectionString))
{
sqlConv.InitializeSQLiteDatabase(sqliteConn, Settings.PragmaParameters);
bool loadSuccess = false;
SqlConversionHandler sqlConversionHandler = new SqlConversionHandler(
delegate(bool done, bool success, int percent, string msg)
{
if (done)
{
if (success)
{
// log success
//Logging.Log(LogLevel.Debug, string.Format("SQLite DB load succeeded: {0}", msg));
loadSuccess = true;
}
else
{
// log failure
//Logging.Log(LogLevel.Error, string.Format("SQLite DB load failed: {0}", msg));
loadSuccess = false;
}
}
});
sqlConv.ConvertToDatabase(Settings.SQLConnectionString, sqliteConn, sqlConversionHandler, null, null, false);
sqliteConn.Close();
Console.WriteLine(loadSuccess);
}
}
