将sqlserver数据库转换为sqlite数据库的程序c#源码

using System;
using System.Collections.Generic;
using System.Text;
using TEFFY.Common.DbAccess;
using System.Windows.Forms;

namespace SqlserverToSQLite
{
    public class DatabaseConvert
    {

        public static bool CreateSQLiteDatabase（string sqlConnString string sqlitePath string password bool createTriggers bool copyData）
        {
            bool ret = false;

            //this.Cursor = Cursors.WaitCursor;
            SqlConversionHandler handler = new SqlConversionHandler（delegate（bool done
                bool success int percent string msg）
            {
                if （done）
                {
                    ret = success;
                }

                //Invoke（new MethodInvoker（delegate（）
                //{
                //    UpdateSensitivity（）;
                //    lblMessage.Text = msg;
                //    pbrProgress.Value = percent;

                //    if （done）
                //    {
                //        btnStart.Enabled = true;
                //        this.Cursor = Cursors.Default;
                //        UpdateSensitivity（）;

                //        if （success）
                //        {
                //            MessageBox.Show（this
                //                msg
                //                “Conversion Finished“
                //                MessageBoxButtons.OK
                //                MessageBoxIcon.Information）;
                //            pbrProgress.Value = 0;
                //            lblMessage.Text = string.Empty;
                //        }
                //        else
                //        {
                //            if （!_shouldExit）
                //            {
                //                MessageBox.Show（this
                //                    msg
                //                    “Conversion Failed“
                //                    MessageBoxButtons.OK
                //                    MessageBoxIcon.Error）;
                //                pbrProgress.Value = 0;
                //                lblMessage.Text = string.Empty;
                //            }
                //            else
                //                Application.Exit（）;
                //        }
                //    }
                //}））;
            }）;
            SqlTableSelectionHandler selectionHandler = new SqlTableSelectionHandler（delegate（List schema）
            {
                List updated = null;
                //Invoke（new MethodInvoker（delegate
                //{
                //    // Allow the user to select which tables to include by showing him the 
                //    // table selection dialog.
                //    TableSelectionDialog dlg = new TableSelectionDialog（）;
                //    DialogResult res = dlg.ShowTables（schema this）;
                //    if （res == DialogResu

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件       2923  2011-06-09 23:41  SqlserverToSQLiteWindowsApplication1App.config

     文件      11776  2011-05-20 11:15  SqlserverToSQLiteWindowsApplication1AxInterop.MSCommLib.dll

     文件        221  2014-01-20 00:34  SqlserverToSQLiteWindowsApplication1inDebugdbsetting.xml

     文件     270336  2009-05-17 20:04  SqlserverToSQLiteWindowsApplication1inDebuglog4net.dll

     文件     102400  2014-01-19 18:22  SqlserverToSQLiteWindowsApplication1inDebugSqlserverToSQLite.exe

     文件       2923  2011-06-09 23:41  SqlserverToSQLiteWindowsApplication1inDebugSqlserverToSQLite.exe.config

     文件      75264  2014-01-19 18:22  SqlserverToSQLiteWindowsApplication1inDebugSqlserverToSQLite.pdb

     文件       5632  2014-03-02 22:11  SqlserverToSQLiteWindowsApplication1inDebugSqlserverToSQLite.vshost.exe

     文件       2923  2011-06-09 23:41  SqlserverToSQLiteWindowsApplication1inDebugSqlserverToSQLite.vshost.exe.config

     文件    1521664  2012-12-31 01:29  SqlserverToSQLiteWindowsApplication1inDebugSystem.Data.SQLite.dll

     文件       7729  2014-01-20 00:34  SqlserverToSQLiteWindowsApplication1inDebug\_log.txt

     文件     270336  2009-05-17 20:04  SqlserverToSQLiteWindowsApplication1inReleaselog4net.dll

     文件      98304  2014-03-02 22:12  SqlserverToSQLiteWindowsApplication1inReleaseSqlserverToSQLite.exe

     文件       2923  2011-06-09 23:41  SqlserverToSQLiteWindowsApplication1inReleaseSqlserverToSQLite.exe.config

     文件      67072  2014-03-02 22:12  SqlserverToSQLiteWindowsApplication1inReleaseSqlserverToSQLite.pdb

     文件    1521664  2012-12-31 01:29  SqlserverToSQLiteWindowsApplication1inReleaseSystem.Data.SQLite.dll

     文件       4166  2011-06-09 23:37  SqlserverToSQLiteWindowsApplication1DatabaseConvert.cs

     文件        508  2010-06-10 19:04  SqlserverToSQLiteWindowsApplication1DbAccessColumnSchema.cs

     文件        375  2010-06-10 19:05  SqlserverToSQLiteWindowsApplication1DbAccessDatabaseSchema.cs

     文件        393  2010-06-10 19:05  SqlserverToSQLiteWindowsApplication1DbAccessForeignKeySchema.cs

     文件        382  2010-06-10 19:05  SqlserverToSQLiteWindowsApplication1DbAccessIndexSchema.cs

     文件      58536  2011-06-09 23:13  SqlserverToSQLiteWindowsApplication1DbAccessSqlServerToSQLite.cs

     文件        419  2010-06-10 19:05  SqlserverToSQLiteWindowsApplication1DbAccessTableSchema.cs

     文件       4330  2010-06-10 19:06  SqlserverToSQLiteWindowsApplication1DbAccessTriggerBuilder.cs

     文件        488  2010-06-10 19:06  SqlserverToSQLiteWindowsApplication1DbAccessTriggerSchema.cs

     文件        475  2010-06-10 19:06  SqlserverToSQLiteWindowsApplication1DbAccessViewSchema.cs

    ..A.SHR       358  2011-02-22 16:55  SqlserverToSQLiteWindowsApplication1DbAccessvssver2.scc

     文件       3277  2014-03-02 22:12  SqlserverToSQLiteWindowsApplication1Form1.cs

     文件       7944  2011-06-09 23:44  SqlserverToSQLiteWindowsApplication1Form1.Designer.cs

     文件       5814  2011-06-09 23:44  SqlserverToSQLiteWindowsApplication1Form1.resx

............此处省略52个文件信息