Using loadrunner to execute an Update on MS-SQL DB

I have a test were I need to update column in Micorsoft DB and this update will trigger sending a file to another application.  I need to send 50,000 updates in an hour.  Is there a way using load runner to execute this SQL? Your assistance is greatly appreciated.

  • Hello

    LR can communicate with MSSQL DB in two different ways: “ODBC” protocol and “.NET” protocol with ADO.NET kind of script.
    Regarding the performance criteria mentioned (50000 update/hour) – it is not possible to prove or disprove that it will happen – it depends on multiple parameters of software and hardware environment where such LR script could run.

    Thanks, Dmitry