Hi Abhinav, I am strognly disagree with the point which is raised by Roman regarding database testing with QTP. Yes,QTP is a tool designed for functional testing and regression testing not only for GUI,We can use for database testing as well. Database testing is nothing but performing the different actions on database.What ever the database type it is(Ex:Oracle-SQL,MS-SQL,MS Access,DB2..etc) Why we go for DB testing? Answer:
Relational database management systems (RDBMSs) often persist mission-critical data which is updated by many applications and potentially thousands if not millions of end users. Furthermore, they implement important functionality in the form of database methods (stored procedures, stored functions, and/or triggers) and database objects (e.g. Java or C# instances). The best way to ensure the continuing quality of these assets, at least from a technical point of view, you should have a full regression test performed on each build for the Database. What to test in DB testing In DB testing we need to check for 1. The field size validation 2. Check constraints. 3. Indexes are done or not (for performance related issues) 4. Stored procedures 5. The field size defined in the application is matching with that in the db. 6. The database is updated correctly as per the expected results by performing CREATE,INSERT,UPDATE commands By using QTP we have to eastablish the connection with DB by using ODBC connection and use the DBCheck Point to perform various actions as described above. Thanks Sridhar On Sun, Apr 4, 2010 at 6:51 AM, Roman Zilber <[email protected]> wrote: > QTP is not a tool for DB testing, everything related DB testing with > QTP can be done with pure VBScript. If there is no GUI involved in > testing, there is no need in QTP. > > Roman > > On Sat, Apr 3, 2010 at 9:57 AM, Abhi Nav <[email protected]> > wrote: > > HI > > > > Need response from your side....Please respond.. > > > > > > thanks and regards > > AB > > > > On Fri, Apr 2, 2010 at 5:17 PM, Abhi Nav <[email protected]> > wrote: > >> > >> Hi, > >> > >> I need to prepare one document, which deals with database testing with > QTP > >> and manual database testing. > >> > >> Relations and comparison between database testing with QTP and manual > >> testing. > >> > >> What are the aspects, that we need to consider while DB (Any DB) testing > >> with QTP and manual testing. > >> > >> Can you please help me out in this. If anybody has any documents which > >> are related to Database testing whether it is manual DB testing or QTP > Db > >> testing > >> > >> > >> Thanks and regards > >> Abhi > >> > >> > > > > -- > > You received this message because you are subscribed to the Google > > "QTP - HP Quick Test Professional - Automated Software Testing" > > group. > > To post to this group, send email to [email protected] > > To unsubscribe from this group, send email to > > [email protected]<mercuryqtp%[email protected]> > > For more options, visit this group at > > http://groups.google.com/group/MercuryQTP?hl=en > > -- > You received this message because you are subscribed to the Google > "QTP - HP Quick Test Professional - Automated Software Testing" > group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<mercuryqtp%[email protected]> > For more options, visit this group at > http://groups.google.com/group/MercuryQTP?hl=en > > To unsubscribe, reply using "remove me" as the subject. > -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en
