用SqlBulkCopy进行大批量数据迁移
1ConnectionStringSettings pubs =
2 ConfigurationManager.ConnectionStrings["PubsData"];
3 DbConnection connection =
4 new SqlConnection(pubs.ConnectionString);
5 ConnectionStringSettings bulkCopy =
6 ConfigurationManager.ConnectionStrings["BulkCopy"];
7 SqlConnection bulkCopyConnection =
8 new SqlConnection(bulkCopy.ConnectionString);
9 DbCommand cmd = connection.CreateCommand();
10 cmd.CommandType = CommandType.Text;
11 cmd.CommandText = "SELECT stor_name FROM Stores";
12 connection.Open();
13 bulkCopyConnection.Open();
14 DbDataReader rdr = cmd.ExecuteReader();
15 SqlBulkCopy bc = new SqlBulkCopy(bulkCopyConnection);
16 bc.DestinationTableName = "StoreList";
17 bc.WriteToServer(rdr);
18 connection.Close();
19 bulkCopyConnection.Close();
20 MessageBox.Show("Done with bulk copy");
2 ConfigurationManager.ConnectionStrings["PubsData"];
3 DbConnection connection =
4 new SqlConnection(pubs.ConnectionString);
5 ConnectionStringSettings bulkCopy =
6 ConfigurationManager.ConnectionStrings["BulkCopy"];
7 SqlConnection bulkCopyConnection =
8 new SqlConnection(bulkCopy.ConnectionString);
9 DbCommand cmd = connection.CreateCommand();
10 cmd.CommandType = CommandType.Text;
11 cmd.CommandText = "SELECT stor_name FROM Stores";
12 connection.Open();
13 bulkCopyConnection.Open();
14 DbDataReader rdr = cmd.ExecuteReader();
15 SqlBulkCopy bc = new SqlBulkCopy(bulkCopyConnection);
16 bc.DestinationTableName = "StoreList";
17 bc.WriteToServer(rdr);
18 connection.Close();
19 bulkCopyConnection.Close();
20 MessageBox.Show("Done with bulk copy");