I’ve a system the place my TCP/IP command immediate utility obtain information and insert that information in [database1].[mytable]
Now i wish to transfer that information from [database1].[mytable] to [database2].[anothertable] when any new file insert in [database1].[mytable] with out shedding any single information.
And there are a approx
70/100 data insert at each 1 second in [database1].[mytable]. Now i wish to transfer that information and need to do some calculation after which insert into
I’ve tried triggered and Saved process as effectively however it take an excessive amount of database reminiscence although someday my db hangs when there are concurrent consumer attempt to join.
So i’ve learn and give you resolution like Sql service dealer and SqlDependency with C# utility.
So my questions is am i able to depend on Sql service dealer or SqlDependency to realize this ? As a result of i don’t wish to misplaced/drop my any information as this are essential information.
Any strategies ?