/// <summary>

    /// Tutorials for transferring data from SqlSrver to MySql

    /// </summary>

    /// <param name="sender"></param>

    /// <param name="e"></param>

    protected void TransferSqlServerDataInToMySql(object sender, EventArgs e)

    {

        string SqlConnStr = ConfigurationManager.ConnectionStrings["SqlConnectionString"].ToString();

        string MySqlConnStr = ConfigurationManager.AppSettings["MySqlConnectionString"].ToString();



        DataSet SqldSet = new DataSet(); // SqlServer Dataset that holds Sql Server data

        DataSet MySqldSet = new DataSet(); //MySql dataset that will be used to push data into MySql database



        try

        {

            // SqlServer - get myTables data from Sql Server

            using (SqlConnection conn = new SqlConnection(SqlConnStr))

            {

                conn.Open();

                using (SqlDataAdapter dAd = new SqlDataAdapter("select * from myTables", conn))

                {

                    dAd.Fill(SqldSet, "myTables");

                }

            }



            lblMessage.Text += "Sql table myTables: " + SqldSet.Tables[0].Rows.Count.ToString() + " records found";



            // Connect to MySql database and have as there is no data into MySql table yet so just get the schema into DataSet

            using (MySqlConnection conn = new MySqlConnection(MySqlConnStr))

            {

                conn.Open();

                using (MySqlDataAdapter dAd = new MySqlDataAdapter("select * from myTables", conn))

                {



                    dAd.Fill(MySqldSet, "myTables"); // Got the empty table of MySql

                    // Loop through all rows of Sql server data table and add into MySql dataset

                    foreach (DataRow row in SqldSet.Tables["myTables"].Rows)

                    {

                        MySqldSet.Tables[0].NewRow();

                        MySqldSet.Tables[0].Rows.Add(row.ItemArray);

                    }

                    // Now we have all rows of Sql Server into MySql server dataset

                    // Create a command builder to update MySql dataset

                    MySqlCommandBuilder cmd = new MySqlCommandBuilder(dAd);

                    // Following update command will push all added rows into MySql dataset to database

                    dAd.Update(MySqldSet, "myTables"); // We are done !!!



                }

            }



            lblMessage.Text += "<br />MySql myTables: " + MySqldSet.Tables[0].Rows.Count.ToString() + " records found <hr />";

        }

        catch (Exception ee)

        {

            lblMessage.Text = ee.Message.ToString();

        }

    }