TO PERFORM BULK COPY FROM ONE DATABASE TO ANOTHER IN ASP.NET

C#
    using system.data.sqlclient;
button click

{

    string sqlQuery = "Select * From publishers";

    string connString = "Data Source=Local;Initial Catalog=PUBS;Integrated Security=True";

    SqlConnection sourceConn= new SqlConnection(connString);

    SqlConnection destConn = new SqlConnection(connString);

    sourceConn.Open();

    destConn.Open();

    SqlCommand command = new SqlCommand(sqlQuery, sourceConn);

    SqlDataReader reader = command.ExecuteReader();

    SqlBulkCopy bulkCopy = new SqlBulkCopy(destConn);

    bulkCopy.DestinationTableName = "BulkCopyPublishers";

    bulkCopy.WriteToServer(reader);

    bulkCopy.Close();

    sourceConn.Close();

    destConn.Close();

    Label1.Text = "Data copied successfully";

}