C# Class SQLiteConversionEngine.Converters.SQLiteToSqlServerConverter

Inheritance: BaseConverter
Datei anzeigen Open project: johnmbaughman/SQLiteConverter

Public Methods

Method Description
ConvertToDatabase ( SqlConnection sqlServerConnection, SQLiteConnection sqliteConnection, SqlConversionHandler sqlConversionHandler, SqlTableSelectionHandler sqlTableSelecttionHandler, FailedViewDefinitionHandler failedViewDefinitionHandler, bool createTriggers ) : void
ConvertToDatabase ( string sqlServerConnectionString, SQLiteConnection sqliteConnection, SqlConversionHandler sqlConversionHandler, SqlTableSelectionHandler sqlTableSelectionHandler, FailedViewDefinitionHandler failedViewDefinitionHandler, bool createTriggers ) : void
ConvertToDatabase ( string sqlServerConnectionString, string sqliteConnectionString, SqlConversionHandler sqlConversionHandler, SqlTableSelectionHandler sqlTableSelectionHandler, FailedViewDefinitionHandler failedViewDefinitionHandler, bool createTriggers ) : void
SQLiteToSqlServerConverter ( ) : System
SQLiteToSqlServerConverter ( List tablesToLoad ) : System

Protected Methods

Method Description
BuildSourceTableQuery ( TableSchema ts ) : string
ConvertSourceDatabaseToDestination ( SqlConnection sqlConnection, SQLiteConnection sqliteConnection, SqlConversionHandler sqlConversionHandler, SqlTableSelectionHandler sqlTableSelectionHandler, FailedViewDefinitionHandler failedViewDefinitionHandler, bool createTriggers ) : void
CopySourceDatabaseRowsToDestination ( SqlConnection sqlConnection, SQLiteConnection sqliteConnection, List schema, SqlConversionHandler handler ) : void
CreateForeignKeySchema ( IDbConnection conn, TableSchema ts ) : void
CreateTableSchema ( IDbConnection conn, string tableName, string tschma ) : TableSchema
ReadSourceSchema ( SqlConnection sqlServerConnection, SqlConversionHandler handler, SqlTableSelectionHandler selectionHandler ) : DatabaseSchema

Method Details

BuildSourceTableQuery() protected method

protected BuildSourceTableQuery ( TableSchema ts ) : string
ts SQLiteConversionEngine.ConversionData.TableSchema
return string

ConvertSourceDatabaseToDestination() protected method

protected ConvertSourceDatabaseToDestination ( SqlConnection sqlConnection, SQLiteConnection sqliteConnection, SqlConversionHandler sqlConversionHandler, SqlTableSelectionHandler sqlTableSelectionHandler, FailedViewDefinitionHandler failedViewDefinitionHandler, bool createTriggers ) : void
sqlConnection System.Data.SqlClient.SqlConnection
sqliteConnection System.Data.SQLite.SQLiteConnection
sqlConversionHandler SqlConversionHandler
sqlTableSelectionHandler SqlTableSelectionHandler
failedViewDefinitionHandler FailedViewDefinitionHandler
createTriggers bool
return void

ConvertToDatabase() public method

public ConvertToDatabase ( SqlConnection sqlServerConnection, SQLiteConnection sqliteConnection, SqlConversionHandler sqlConversionHandler, SqlTableSelectionHandler sqlTableSelecttionHandler, FailedViewDefinitionHandler failedViewDefinitionHandler, bool createTriggers ) : void
sqlServerConnection System.Data.SqlClient.SqlConnection
sqliteConnection System.Data.SQLite.SQLiteConnection
sqlConversionHandler SqlConversionHandler
sqlTableSelecttionHandler SqlTableSelectionHandler
failedViewDefinitionHandler FailedViewDefinitionHandler
createTriggers bool
return void

ConvertToDatabase() public method

public ConvertToDatabase ( string sqlServerConnectionString, SQLiteConnection sqliteConnection, SqlConversionHandler sqlConversionHandler, SqlTableSelectionHandler sqlTableSelectionHandler, FailedViewDefinitionHandler failedViewDefinitionHandler, bool createTriggers ) : void
sqlServerConnectionString string
sqliteConnection System.Data.SQLite.SQLiteConnection
sqlConversionHandler SqlConversionHandler
sqlTableSelectionHandler SqlTableSelectionHandler
failedViewDefinitionHandler FailedViewDefinitionHandler
createTriggers bool
return void

ConvertToDatabase() public method

public ConvertToDatabase ( string sqlServerConnectionString, string sqliteConnectionString, SqlConversionHandler sqlConversionHandler, SqlTableSelectionHandler sqlTableSelectionHandler, FailedViewDefinitionHandler failedViewDefinitionHandler, bool createTriggers ) : void
sqlServerConnectionString string
sqliteConnectionString string
sqlConversionHandler SqlConversionHandler
sqlTableSelectionHandler SqlTableSelectionHandler
failedViewDefinitionHandler FailedViewDefinitionHandler
createTriggers bool
return void

CopySourceDatabaseRowsToDestination() protected method

protected CopySourceDatabaseRowsToDestination ( SqlConnection sqlConnection, SQLiteConnection sqliteConnection, List schema, SqlConversionHandler handler ) : void
sqlConnection System.Data.SqlClient.SqlConnection
sqliteConnection System.Data.SQLite.SQLiteConnection
schema List
handler SqlConversionHandler
return void

CreateForeignKeySchema() protected method

protected CreateForeignKeySchema ( IDbConnection conn, TableSchema ts ) : void
conn IDbConnection
ts SQLiteConversionEngine.ConversionData.TableSchema
return void

CreateTableSchema() protected method

protected CreateTableSchema ( IDbConnection conn, string tableName, string tschma ) : TableSchema
conn IDbConnection
tableName string
tschma string
return SQLiteConversionEngine.ConversionData.TableSchema

ReadSourceSchema() protected method

protected ReadSourceSchema ( SqlConnection sqlServerConnection, SqlConversionHandler handler, SqlTableSelectionHandler selectionHandler ) : DatabaseSchema
sqlServerConnection System.Data.SqlClient.SqlConnection
handler SqlConversionHandler
selectionHandler SqlTableSelectionHandler
return DatabaseSchema

SQLiteToSqlServerConverter() public method

public SQLiteToSqlServerConverter ( ) : System
return System

SQLiteToSqlServerConverter() public method

public SQLiteToSqlServerConverter ( List tablesToLoad ) : System
tablesToLoad List
return System