Re: Saving data quickly to a database

Tech-Archive recommends: Fix windows errors by optimizing your registry


Bulk Insert using Xml is my favorite tool of choice.

See

http://groups.google.com/group/microsoft.public.sqlserver.programming/msg/5491c0640ddf9680


My example is (to me) a better thought out version and better tweaked
version of the one seen here:
http://support.microsoft.com/kb/315968


One key to this approach is that indexes are rebuilt ~after the bulk insert,
which is contrary to the "row by row" way of doing it.





"Jon" <.> wrote in message news:u$$GobtUIHA.1168@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I plan to import some data from an old DOS-based programme. The data file
format that this programme
produced appears to be proprietary, but I've managed to reverse engineer
the format and have put
together a C# programme to do this.

The data will be imported into a database table.

Do you have any general tips on how store the data to a database (SQL
Server 2005 Express) quickly?
The amount of data could be up to 100Mbytes.

Should I put it into a DataTable first then save this to the database, or
should I send it directly
to the database (eg using SQL), or is there another way?

The data will overwrite anything in the database, so no merging is
required.

Thanks...




.

Relevant Pages

  • Re: Performance of ADO.NET dataset
    ... I considered the XML technique with ... I am more knowledgeable about SQL stored procedures, ... faster when done in the database. ... >> Is there a way to do a bulk insert from an ADO.NET dataset? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: using a dataset to buffer insert?
    ... It sounds like you're looking for the BULK INSERT statement but I think it's ... necessary to define the data source here for further information/guidance. ... and of course things slow down when i use a sql insert statement for each. ... database, it is likely that records will have be deleted from ...
    (microsoft.public.sqlserver.programming)
  • Re: Saving data quickly to a database
    ... I plan to import some data from an old DOS-based programme. ... format that this programme ... The data will be imported into a database table. ... Do you have any general tips on how store the data to a database (SQL ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)