static void Main(string[] args)

{

    /******************************************************************

     * Bulk copy Order Details data from Northwind to Northwind2 database

     *****************************************************************/

    string northwindConnectionString =

        "Data Source=.;Initial Catalog=Northwind;Integrated Security=True";

    string northwind2ConnectionString =

        "Data Source=.;Initial Catalog=Northwind2;Integrated Security=True";

    using (SqlConnection northwindConnection =

        new SqlConnection(northwindConnectionString))

    {

        northwindConnection.Open();

        SqlCommand command =

            new SqlCommand("Select * from [order details]", northwindConnection);

        SqlDataReader dataReader = command.ExecuteReader();

        using (SqlConnection northwind2Connection =

            new SqlConnection(northwind2ConnectionString))

        {

            northwind2Connection.Open();

            SqlBulkCopy bulkCopy = new SqlBulkCopy(northwind2Connection);

            bulkCopy.DestinationTableName = "[Order Details]";

            bulkCopy.WriteToServer(dataReader);

            northwind2Connection.Close();

        }

        northwindConnection.Close();

    }

    Console.WriteLine("Bulk Copy Operation Successful");

    Console.WriteLine("Press any key to exit...");

    Console.ReadKey();

}

insert bulk [Order Details] ([OrderID] Int,

[ProductID] Int,

[UnitPrice] Money,

[Quantity] SmallInt,

[Discount] Real)