Skip to content

AscarGb/DbfToMsSQL

Repository files navigation

DbfToMsSQL

App for loading large dbf files into ms sql server database via SqlBulkCopy https://github.com/AscarGb/DbfToMsSQL/releases

DbfToMsSQL.Loader

Only library

NuGet

Usage

using (SqlConnection connection = new SqlConnection(ConnestionString))
{
  await connection.OpenAsync();  
  using (DBFReader reader = new DBFReader("FileName.DBF", 866, "TableName"))
  {
    reader.OnLoad += BulkReader_OnLoad;
    using (SqlBulkCopy loader = new SqlBulkCopy(connection))
    {
      loader.DestinationTableName = "TableName";
      loader.BulkCopyTimeout = int.MaxValue;
      await loader.WriteToServerAsync(reader);
    }
  }
}

About

App for loading large dbf files into ms sql server database via SqlBulkCopy

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages