Re: Does Loadrunner Vuser support calling a SQL file? (598 Views)
Reply
Regular Advisor
ray500
Posts: 140
Registered: ‎10-27-2011
Message 1 of 4 (1,053 Views)

Does Loadrunner Vuser support calling a SQL file?

Is there anyway to call a SQL file(specifically SQL Server) in Loadrunner and have Loadrunner execute it?   I know you can run SQL statements using lr_db_executeSQLStatement(Web Service protocol) or by lrd_stmt(ODBC protocol)  but these accept one SQL statement.   I need to run a large SQL script that would be too complex to break down into several of the above functions.

 

If running a file is not an option,  what about calling stored procedures?  Can they be called in Loadrunner?

 

Thanks,

Raymond

HP Expert
Editus
Posts: 650
Registered: ‎04-06-2011
Message 2 of 4 (1,033 Views)

Re: Does Loadrunner Vuser support calling a SQL file?

This is not possible, however  you can create a stored procedure on SQL and callit from LoadRunner.

hope this helps.

 

cheers

Regular Advisor
ray500
Posts: 140
Registered: ‎10-27-2011
Message 3 of 4 (1,031 Views)

Re: Does Loadrunner Vuser support calling a SQL file?

Thanks Editus!   I also have started using the .NET protocol using C# in Loadrunner and being able to call multiple SQL statements and parameterize much better than in ODBC protocol.

Occasional Advisor
Vaibhav-666
Posts: 8
Registered: ‎07-16-2013
Message 4 of 4 (598 Views)

Re: Does Loadrunner Vuser support calling a SQL file?

Hi,

 

I would really appreciate if you can post some .NET examples to execute long queries from a SQL File.

 

Thanks in advance,

 

Vaibhav

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.