合并两个SQLite数据库文件(C#.NET)

我找到了这个,这是从几个不同的论坛问题中引用的. http://old.nabble.com/Attempting-to-merge-large-databases-td18131366.html

我尝试了下面的查询,我从我提供的链接构建,但它们导致异常,数据库根本没有合并,并且原始数据库不会发生任何变化.

attach 'c:\test\b.db3' as toMerge;   
insert into AuditRecords SELEct * FROM toMerge.AuditRecords;

这是我的查询代码.

public void importData(String fileLoC)
    {
        sqlitetransaction trans;
        String sql = "ATTACH '" + fileLoc + "' AS TOMERGE";
        sqliteCommand cmd = new sqliteCommand(SQL);
        cmd.Connection = connection;
        connection.open();
        trans = connection.begintransaction();
        int retval = 0;
        try
        {
            retval = cmd.ExecuteNonQuery();
        }
        catch (Exception)
        {
            trans.RollBACk();
            messageBox.Show("An error occurred,your import was not completed.");
        }
        finally
        {
            trans.Commit();
            cmd.Dispose();
            connection.Close();
        }

        SQL = "INSERT INTO SUBCONTRACTOR SELECT * FROM tOMERGE.SUBCONTRACTOR";
        cmd = new sqliteCommand(SQL);
        cmd.Connection = connection;
        connection.open();
        trans = connection.begintransaction();
        retval = 0;
        try
        {
            retval = cmd.ExecuteNonQuery();
        }
        catch (Exception)
        {
            trans.RollBACk();
            messageBox.Show("An error occurred,your import was not completed.");
        }
        finally
        {
            trans.Commit();
            cmd.Dispose();
            connection.Close();
        }
    }

我的问题是,我做错了什么？是否有人熟悉insert命令？我不确定它是否会根据需要排除重复项.