Method | Description | |
---|---|---|
CancelConversion ( ) : void |
Cancels the conversion.
|
|
ConvertSqlServerToSQLiteDatabase ( string sqlServerConnString, string sqlitePath, string password, SqlConversionHandler handler, SqlTableSelectionHandler selectionHandler, FailedViewDefinitionHandler viewFailureHandler, bool createTriggers ) : void |
This method takes as input the connection string to an SQL Server database and creates a corresponding SQLite database file with a schema derived from the SQL Server database. The method continues asynchronously in the background and the caller returned immediatly. |
|
WriteTriggerSchema ( TriggerSchema ts ) : string |
Gets a create script for the triggerSchema in sqlite syntax
|
Method | Description | |
---|---|---|
AddSQLiteTable ( |
Creates the CREATE TABLE DDL for SQLite and a specific table.
|
|
AddSQLiteView ( |
||
AddTableTriggers ( |
||
AddTriggersForForeignKeys ( string sqlitePath, IEnumerable |
||
AdjustDefaultValue ( string val ) : string |
More adjustments for the DEFAULT value clause.
|
|
BuildColumnStatement ( DbAccess.ColumnSchema col, DbAccess.TableSchema ts, bool &pkey ) : string |
Used when creating the CREATE TABLE DDL. Creates a single row for the specified column.
|
|
BuildCreateIndex ( string tableName, DbAccess.IndexSchema indexSchema ) : string |
Creates a CREATE INDEX DDL for the specified table and index schema.
|
|
BuildCreateTableQuery ( DbAccess.TableSchema ts ) : string |
returns the CREATE TABLE DDL for creating the SQLite table from the specified table schema object.
|
|
BuildIndexSchema ( string indexName, string desc, string keys ) : IndexSchema |
Builds an index schema object from the specified components (Read from SQL Server).
|
|
BuildSQLiteInsert ( TableSchema ts ) : SQLiteCommand |
Creates a command object needed to insert values into a specific SQLite table.
|
|
BuildSqlServerTableQuery ( TableSchema ts ) : string |
Builds a SELECT query for a specific table. Needed in the process of copying rows from the SQL Server database to the SQLite database.
|
|
CastValueForColumn ( object val, ColumnSchema columnSchema ) : object |
Used in order to adjust the value received from SQL Servr for the SQLite database.
|
|
CheckCancelled ( ) : void |
Convenience method for checking if the conversion progress needs to be cancelled.
|
|
ConvertSqlServerDatabaseToSQLiteFile ( string sqlConnString, string sqlitePath, string password, SqlConversionHandler handler, SqlTableSelectionHandler selectionHandler, FailedViewDefinitionHandler viewFailureHandler, bool createTriggers ) : void |
Do the entire process of first reading the SQL Server schema, creating a corresponding SQLite schema, and copying all rows from the SQL Server database to the SQLite database.
|
|
CopySqlServerRowsToSQLiteDB ( string sqlConnString, string sqlitePath, List |
Copies table rows from the SQL Server database to the SQLite database.
|
|
CreateForeignKeySchema ( SqlConnection conn, TableSchema ts ) : void |
Add foreign key schema object from the specified components (Read from SQL Server).
|
|
CreateSQLiteConnectionString ( string sqlitePath, string password ) : string |
Creates SQLite connection string from the specified DB file path.
|
|
CreateSQLiteDatabase ( string sqlitePath, DatabaseSchema schema, string password, SqlConversionHandler handler, FailedViewDefinitionHandler viewFailureHandler ) : void |
Creates the SQLite database from the schema read from the SQL Server.
|
|
CreateTableSchema ( SqlConnection conn, string tableName, string tschma ) : TableSchema |
Creates a TableSchema object using the specified SQL Server connection and the name of the table for which we need to create the schema.
|
|
DiscardNational ( string value ) : string |
Discards the national prefix if exists (e.g., N'sometext') which is not supported in SQLite.
|
|
FixDefaultValueString ( string colDefault ) : string |
Does some necessary adjustments to a value string that appears in a column DEFAULT clause.
|
|
GetDbTypeOfColumn ( ColumnSchema cs ) : DbType |
Matches SQL Server types to general DB types
|
|
GetNormalizedName ( string str, List |
Used in order to avoid breaking naming rules (e.g., when a table has a name in SQL Server that cannot be used as a basis for a matching index name in SQLite).
|
|
IsSingleQuoted ( string value ) : bool | ||
IsValidDefaultValue ( string value ) : bool |
Check if the DEFAULT clause is valid by SQLite standards
|
|
ParseBlobAsGuid ( byte blob ) : Guid | ||
ParseStringAsGuid ( string str ) : Guid | ||
ReadSqlServerSchema ( string connString, SqlConversionHandler handler, SqlTableSelectionHandler selectionHandler ) : DatabaseSchema |
Reads the entire SQL Server DB schema using the specified connection string.
|
|
StripParens ( string value ) : string |
Strip any parentheses from the string.
|
|
ValidateDataType ( string dataType ) : void |
Small validation method to make sure we don't miss anything without getting an exception.
|
public static ConvertSqlServerToSQLiteDatabase ( string sqlServerConnString, string sqlitePath, string password, SqlConversionHandler handler, SqlTableSelectionHandler selectionHandler, FailedViewDefinitionHandler viewFailureHandler, bool createTriggers ) : void | ||
sqlServerConnString | string | The connection string to the SQL Server database. |
sqlitePath | string | The path to the SQLite database file that needs to get created. |
password | string | The password to use or NULL if no password should be used to encrypt the DB |
handler | SqlConversionHandler | A handler delegate for progress notifications. |
selectionHandler | SqlTableSelectionHandler | The selection handler that allows the user to select which /// tables to convert |
viewFailureHandler | FailedViewDefinitionHandler | |
createTriggers | bool | |
return | void |
public static WriteTriggerSchema ( TriggerSchema ts ) : string | ||
ts | TriggerSchema | Trigger to script |
return | string |