11-28-2011 02:12 PM
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?
12-02-2011 11:07 AM
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.