That is a GUI testing, and you need to use DB queries, discussion was not about that type of testing. There no doubt that it is handy to use ability of QTP connect DB.
Roman On Fri, Apr 9, 2010 at 9:07 PM, <[email protected]> wrote: > Hey guys: What about the possibility that the DB has the right data, but > the Web App some how gets it screwed up somewhere between there, the DB > server, the middleware, the App server and the UI? > > In a message dated 4/8/10 10:26:40 A.M. Eastern Daylight Time, > [email protected] writes: > > The point on by Roman on DB testing is very valid.first of all why to use a > GUI automation for DB testing. > I haven't done much on DB testing,but what i feel is you might end in > writing some VB Script to test your DB which can be done with out QTP,Are > there any DB specific function ,tool or utility available in QTP? ,i think > no(but not sure on this) > Note these are doubts i have,so don't consider this as a solution,if you > search answer for such doubts you may get answers. > First dont jump into automation with out analysing why should I automation > and what is my goal? Then search for answers like which > tool,framework,approach can be used to achieve the goal. > > > On 8 April 2010 09:55, Roman Zilber <[email protected]> wrote: > >> Dhanasekar, >> >> Thanks for the support, but been moderator is not an augment in a >> discussion. I personally almost don't use QTP for access to DB, but I have >> friends who work hard with DB testing, no one of them uses QTP for it. >> >> Roman >> >> On Wed, Apr 7, 2010 at 9:06 PM, Dhanasekar Subramaniam < >> [email protected]> wrote: >> >>> Mr Sridhar, >>> Have you ever read the rules and FAQ's of this group? If not please go >>> and read that first >>> http://groups.google.com/group/mercuryqtp/web/rules >>> Roman is All Time top poster to this group,I think he is now moderator >>> as I am not seeing any activity from Dmitry >>> Motevich<http://groups.google.com/groups/profile?enc_user=V0buwxIAAABGOUupnLCCiLVcHz5weuuH8rhlH0Pnl47z4AZhN98BFg&group=mercuryqtp> >>> >>> Regards, >>> Dhanasekar S >>> http://testingideas.wordpress.com >>> >>> >>> On 8 April 2010 08:53, S R I D H A R <[email protected]> wrote: >>> >>>> Hi Roman, >>>> >>>> What is your opinion?.If you dont mind do you have any experience in >>>> Automation testing with QTP?. >>>> Let me know what is your concern regarding database testing with QTP,On >>>> what basis you are telling that QTP is not suitable for database testing?. >>>> >>>> Thanks >>>> Sridhar >>>> >>>> On Thu, Apr 8, 2010 at 7:13 AM, Roman Zilber <[email protected]> wrote: >>>> >>>>> I think, the link, that you gave, supports my opinion, not yours. >>>>> >>>>> Roman >>>>> >>>>> On Sat, Apr 3, 2010 at 10:24 PM, S R I D H A R <[email protected]> >>>>> wrote: >>>>> > >>>>> > >>>>> > On Sun, Apr 4, 2010 at 10:51 AM, S R I D H A R <[email protected]> >>>>> wrote: >>>>> >> >>>>> >> 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. >>>>> > >>>>> > >>>>> > For further details info pls check this link >>>>> > >>>>> http://www.oracle.com/technology/oramag/oracle/05-jul/o45testing.html >>>>> >> >>>>> >> >>>>> >> 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]<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 >>>>> >>>> >>>> -- >>>> 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 >>>> >>> >>> >>> >>> -- >>> Regards, >>> Dhanasekar S. >>> http://testingideas.wordpress.com Twitter : sdhanasekar >>> --------------------------------------------------------- >>> Let us make the World Greener >>> http://www.greenpeace.org/international/ >>> ----------------------------------------------------------- >>> >>> -- >>> 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 >> > > > > -- > Regards, > Dhanasekar S. > http://testingideas.wordpress.com Twitter : sdhanasekar > --------------------------------------------------------- > Let us make the World Greener > http://www.greenpeace.org/international/ > ----------------------------------------------------------- > > > -- > 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 > -- 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
