Question

I could use some suggestions / ideas. I wrote a console application that queries all data from a table in MS Access (I know, but I inherited it) to a SQL table. It runs every morning as a scheduled task. The fields between the two tables are not identical. Currently I select all data from the MS Access table, loop through the dataset and insert each row into the SQL table. I also write a quick log file in the process. It works, but it s not fast. I would appreciate any ideas that you may have to improve the process. Thanks!

Answer 1

SqlBulkCopy par

缩略语

你们必须提高自己对主要钥匙的认同领域价值。为此,首先 gr清了你离开的最后身份现场价值:

select top 1 id_customer from customers order by id_customer desc

然后通过您的<代码>DataSet<>/code> 变式。

或您可使用

采用SqlBulkCopy的示范代码:

public static void BulkLoadDataTable(DataTable table, string destinationTable)
{
  using (SqlBulkCopy bulkCopy = new SqlBulkCopy(_connectionString))
  {
    bulkCopy.BulkCopyTimeout = 1200;
    bulkCopy.DestinationTableName = destinationTable;
    bulkCopy.WriteToServer(table);
  }
}

高度分类的数据:

using System;
using System.Data;

public class CustomersDataTable : DataTable
{
  public CustomersDataTable() : base()
  {
    base.TableName = "Customers";
    Columns.Add(new DataColumn("id_customer", typeof(int)));
    Columns.Add(new DataColumn("first_name", typeof(string)));
    Columns.Add(new DataColumn("last_name", typeof(string)));
    Columns.Add(new DataColumn("active", typeof(bool)));
  }
}

Answer 2

你们是否看过信息社会首脑会议的一揽子计划? 我想首先谈谈这一点。如果你不能够接触到,那么就看这里提到的SqlBulkCopy类。

http://www.sqlteam.com/article/using-select-to-insert-records” rel=“nofollow noreferer”>SlectT 附有INSERT的声明。

友情链接