如何使用.NET 以编程方式复制SQL Server 2000表？

using System;
using System.Data.SqlClient;
using System.Data;

namespace CopyTableFromSQLServer2000
{
    class Program
    {
        static void Main(string[] args)
        {
            string sourceConnectionString = "Data Source=sourceServer;Initial Catalog=sourceDatabase;Integrated Security=True";
            string destinationConnectionString = "Data Source=destinationServer;Initial Catalog=destinationDatabase;Integrated Security=True";

            using (SqlConnection sourceConnection = new SqlConnection(sourceConnectionString))
            using (SqlConnection destinationConnection = new SqlConnection(destinationConnectionString))
            {
                sourceConnection.Open();
                destinationConnection.Open();

                using (SqlCommand sourceCommand = new SqlCommand("SELECT * FROM sourceTable", sourceConnection))
                using (SqlDataReader sourceDataReader = sourceCommand.ExecuteReader())
                using (SqlBulkCopy bulkCopy = new SqlBulkCopy(destinationConnection))
                {
                    bulkCopy.DestinationTableName = "destinationTable";

                    while (sourceDataReader.Read())
                    {
                        bulkCopy.WriteToServer(sourceDataReader);
                    }
                }
            }
        }
    }
}