"calderara" <calderara@discussions.microsoft.com> wrote in message
news:E503DA44-DA42-4AE0-9FF2-B6E30EFA192A@microsoft.com...
> Dear all,
>
> I have an old database structure which has been decided at the time of SQL
> server 6.x.
> This databased structure is build with HISTORY TABLE and its equivalent
> BUFFER table- For example if a table is called EVENTHIST then its buffer
> table will be named BUFF_EVENTHIST.
>
> Then we have an old client application which connect to that SQL server
> database with ODBC and then transfer some data to the BUFF tables, when
> the
> transfert is complete it calls a store procedure which :
>
> - transfert all BUFF table content to HISTORY table
> - Clear all BUFF table.
>
> Does this type of mecanism can still remains with ADO.NET or can I totally
> remove those BUFF table and write directly in HISTORY table ?
>
> Is it really needed? for me sounds that I can remove them but in
> performance
> view will it be ok ?
>
>
> Thanks fro your help
> regards