Exemple #1
0
        /*private void ProcesarSQL2000()
        {
            DBDiff.Schema.SQLServer2000.Model.Database origen;
            DBDiff.Schema.SQLServer2000.Model.Database destino;

            DBDiff.Schema.SQLServer2000.Generate sql = new DBDiff.Schema.SQLServer2000.Generate();

            lblMessage.Text = "Leyendo tablas de origen...";
            sql.OnTableProgress += new Progress.ProgressHandler(sql_OnTableProgress);
            //sql.ConnectioString = txtConnectionOrigen.Text;
            origen = sql.Process();

            //sql.ConnectioString = txtConnectionDestino.Text;
            lblMessage.Text = "Leyendo tablas de destino...";
            destino = sql.Process();

            origen = DBDiff.Schema.SQLServer2000.Generate.Compare(origen, destino);
            //this.txtScript.SQLType = SQLEnum.SQLTypeEnum.SQLServer;
            //this.txtDiferencias.SQLType = SQLEnum.SQLTypeEnum.SQLServer;
            this.txtDiferencias.Text = origen.ToSQLDiff();

        }
        */
        private void btnCompareTableData_Click(object sender, EventArgs e)
        {
            TreeView tree = (TreeView)schemaTreeView1.Controls.Find("treeView1", true)[0];
            ISchemaBase selected = (ISchemaBase)tree.SelectedNode.Tag;
            DataCompareForm dataCompare = new DataCompareForm(selected, mySqlConnectFront1.ConnectionString, mySqlConnectFront2.ConnectionString);
            dataCompare.Show();
        }
        /*private void ProcessSQL2000()
         * {
         *  DBDiff.Schema.SQLServer2000.Model.Database origin;
         *  DBDiff.Schema.SQLServer2000.Model.Database destination;
         *
         *  DBDiff.Schema.SQLServer2000.Generate sql = new DBDiff.Schema.SQLServer2000.Generate();
         *
         *  lblMessage.Text = "Leyendo tablas de origin...";
         *  sql.OnTableProgress += new Progress.ProgressHandler(sql_OnTableProgress);
         *  //sql.ConnectioString = txtConnectionOrigen.Text;
         *  origin = sql.Process();
         *
         *  //sql.ConnectioString = txtConnectionDestination.Text;
         *  lblMessage.Text = "Leyendo tablas de destination...";
         *  destination = sql.Process();
         *
         *  origin = DBDiff.Schema.SQLServer2000.Generate.Compare(origin, destination);
         *  //this.txtScript.SQLType = SQLEnum.SQLTypeEnum.SQLServer;
         *  //this.txtDiferencias.SQLType = SQLEnum.SQLTypeEnum.SQLServer;
         *  this.txtDiferencias.Text = origin.ToSQLDiff();
         *
         *
         * }
         */
        private void btnCompareTableData_Click(object sender, EventArgs e)
        {
            TreeView        tree        = (TreeView)schemaTreeView1.Controls.Find("treeView1", true)[0];
            ISchemaBase     selected    = (ISchemaBase)tree.SelectedNode.Tag;
            DataCompareForm dataCompare = new DataCompareForm(selected, mySqlConnectFront1.ConnectionString, mySqlConnectFront2.ConnectionString);

            dataCompare.Show();
        }