using (SqlConnection sc = new SqlConnection(connectionString))
            { 
sc.Open();
                SqlCommand commandSourceData = new SqlCommand("SELECT * FROM StoresBackup;", sc);
                SqlDataReader reader =  commandSourceData.ExecuteReader();
                using (SqlConnection dc = new  SqlConnection(connectionString))
                { 
dc.Open();
                    using (SqlBulkCopy bulkCopy = new SqlBulkCopy(dc))
                    {
 bulkCopy.DestinationTableName = "Stores";
                         bulkCopy.WriteToServer(reader);
 }