Bulk Copy Operation

string connectionString = "";
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);
        }
    }
}