What would be the best way to update a database. We have data in excel spreadsheet and would it be the best way to update database using QTP script(using ADODB) instead of using a sql query in TOAD . I am just trying to figure out the performance issues or any bottlenecks. Any one please share your experience with DB or advise me the best approach.
Are you trying to Load Testing for your database?, for this you have to use LoadRunner
If you are trying to update database with values in your excel sheet, user normal Database code in QTP to do this.
For i = 1 to DataTable Rows
Excecute Stament (INSERT INTO table_name
VALUES (DataTable("Val1",dtGlobalSheet),DataTable("Val2", dtGlobalSheet),DataTable("Val3",dtGlobalSheet),... )
Is there any specific reason that you want to use QTP to upload the values from an excel to the database. yes ofcourse QTP lets you do it by establishing ADODB connection. But you can also do it by using any Microsoft technology tools such as VB.
Web through IE6,IE7 SP2.
No non-standard controls.