tag:blogger.com,1999:blog-3806208351698608392.post8589824708374020688..comments2023-10-28T16:37:34.195+05:30Comments on Software Testing Space: How to do real database testing (10 tips to perform serious database tests)?Inder P Singhhttp://www.blogger.com/profile/05923580987480854491noreply@blogger.comBlogger23125tag:blogger.com,1999:blog-3806208351698608392.post-79212804196813770402022-09-04T18:50:46.380+05:302022-09-04T18:50:46.380+05:30Nice Blog.. Thanks a lot sql server hostingNice Blog.. Thanks a lot <b><a href="https://www.motherhost.com/cloud/mssql-database/" rel="nofollow">sql server hosting</a></b>Motherhosthttps://www.blogger.com/profile/05194826933252732150noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-54934539641289075512022-08-25T13:13:04.237+05:302022-08-25T13:13:04.237+05:30Thanks for the information. I really like the way ...Thanks for the information. I really like the way you express complex topics in lucid way. It really helps me understand it much better way. <a href="https://nexus-data.io/" rel="nofollow">product details database</a>Jones Hillhttps://www.blogger.com/profile/09788621721468452606noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-85233571160379037792021-06-08T18:26:26.538+05:302021-06-08T18:26:26.538+05:30Thank you for your post, I look for such article a...Thank you for your post, I look for such article along time, today i find it finally. this post give me lots of advise it is very useful for me.<br /><a href="https://https://www.credosystemz.com/training-in-chennai/react-js-training/" rel="nofollow">Reactjs Training in Chennai</a> |<br /><a href="https://https://www.credosystemz.com/training-in-chennai/react-js-training/" rel="nofollow">Best Reactjs Training Institute in Chennai</a> |<br /><a href="https://https://www.credosystemz.com/training-in-chennai/react-js-training/" rel="nofollow">Reactjs course in Chennai</a> |<br /><br />Aishwariyahttps://www.blogger.com/profile/10811656148699205956noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-9155409096136284872021-05-07T16:16:40.893+05:302021-05-07T16:16:40.893+05:30Awesome post Amazon Web Services Training in Chenn...Awesome post <a href="https://www.credosystemz.com/courses/aws-training-chennai/" rel="nofollow">Amazon Web Services Training in Chennai</a> <br />Aishwariyahttps://www.blogger.com/profile/10811656148699205956noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-60132133386909348562020-01-02T12:22:02.268+05:302020-01-02T12:22:02.268+05:30Thank you so much for this nice information. Hope ...Thank you so much for this nice information. Hope so many people will get aware of this and useful as well. And please keep update like this.<br /><br /><a href="https://www.indiumsoftware.com/big-data-services/" rel="nofollow">Big Data Services</a><br /><br /><a href="https://www.indiumsoftware.com/advanced-analytics/" rel="nofollow">Advanced Analytics Solutions</a><br /><br /><a href="https://www.indiumsoftware.com/product-development/" rel="nofollow">Full Stack Development Services</a>Edwardhttps://www.blogger.com/profile/07612909883009539894noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-56363825545570249352012-12-10T07:19:19.188+05:302012-12-10T07:19:19.188+05:30Glimpse of Db testing was narrated and very useful...Glimpse of Db testing was narrated and very useful. Thanks Mr. Inder for sharing!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-40824967738636574272012-10-16T20:37:49.269+05:302012-10-16T20:37:49.269+05:30Thank you, Sanjeev. All the best.Thank you, Sanjeev. All the best.Inder P Singhhttps://www.blogger.com/profile/05923580987480854491noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-70911443259356460922012-10-15T12:14:28.064+05:302012-10-15T12:14:28.064+05:30Hi, I found it very useful in analysis and definin...Hi, I found it very useful in analysis and defining scope of database testing.<br />Sanjeev Soamhttps://www.blogger.com/profile/02460561889050773850noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-58162711145799988162012-10-11T12:25:08.907+05:302012-10-11T12:25:08.907+05:30Very nice article Inder sir.
Very nice article Inder sir.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-33480370919340341242012-09-30T00:51:05.277+05:302012-09-30T00:51:05.277+05:30Can anyone suggest for a good database testing too...Can anyone suggest for a good database testing toolAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-60882900024481269072012-04-05T14:33:21.881+05:302012-04-05T14:33:21.881+05:30Hi, This is nice Article. I have a specific questi...Hi, This is nice Article. I have a specific question regarding DB migration. Let us say If source DB contains 10 tables, which we need to migrate the data to a single table in destination (in our case, source is oracle, destination is sybase). <br />From the scope in DB migration testing // All data related to a particular entity is loaded in each relevant table in the target database// it is not possible to test all the records manually. Do we have any specific tool to compare the source and destination data in this case? Actually I tried long back with DBSOLO, but this tool can only compare the data If source and Destination DB schema's are equivalent and number of tables should be sameKoolDudehttps://www.blogger.com/profile/11884297782104574775noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-72991816940029628922012-03-28T17:55:40.005+05:302012-03-28T17:55:40.005+05:30These points sounds good.
Can someone suggest a g...These points sounds good.<br /><br />Can someone suggest a good database testing tool?Johttps://www.blogger.com/profile/05230645502340765455noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-10408333686930147472011-06-05T21:00:25.654+05:302011-06-05T21:00:25.654+05:30@Digvijay, Database software usually comes with sa...@Digvijay, Database software usually comes with sample databases that you can use. Look it up in the database software help file. Even otherwise, you can create a couple of tables, populate some rows in them and practice. Believe me, there is a lot of practice you can get from 2 tables (even 1 single table).Inder P Singhhttps://www.blogger.com/profile/05923580987480854491noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-56124642017339683572011-06-02T11:42:12.654+05:302011-06-02T11:42:12.654+05:30if i want to do practical for data base testing,fr...if i want to do practical for data base testing,from where i can get the dummy database in which i can practice data base testingAnonymoushttps://www.blogger.com/profile/15555487404833338165noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-31291354490245372082011-05-15T01:52:22.442+05:302011-05-15T01:52:22.442+05:30Inder
This is a good article, tnx for sharing. On...Inder<br /><br />This is a good article, tnx for sharing. On a separte note, Chandu could you share the links on db testing tutorial. It might be useful to someone in need.<br /><br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-30700822684534695722011-04-15T21:39:43.539+05:302011-04-15T21:39:43.539+05:30i need more suggestionsi need more suggestionsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-50902545286545337162011-02-23T17:18:55.912+05:302011-02-23T17:18:55.912+05:30please any one send me some database testing learn...please any one send me some database testing learning tutorial links to mail chandu.sk4@gmail.comchanduhttps://www.blogger.com/profile/04609003927718283085noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-525712683192895652011-02-09T13:07:07.973+05:302011-02-09T13:07:07.973+05:30Nice article...it was worth reading it.
Thank youNice article...it was worth reading it.<br />Thank youAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-63573336765118141722010-08-13T17:27:01.345+05:302010-08-13T17:27:01.345+05:30inder sir......thanks for detailed analysis of dat...inder sir......thanks for detailed analysis of database testing....I also liked your blog of database testing plan..i dont think anywhere else we could find such detail analysis of as such, DB testing plan. Just one request, i want to put in front of you is that, it would be very grateful if you could write a dedicated blog on the topic 'Database normalisation and its all forms:1NF etc.' because I have read about it at many places (in wiki or other blogs) but could not relate much with real life project data...I askd some of my friends also about this concept, they also have a bit theoretical idea of that, which is very hard to implement in the real DB tables. So any such detail blog emphasizing on that particular topic could be very useful.<br /><br />Thanks in advance..Unknownhttps://www.blogger.com/profile/06657426144609599543noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-6165394980058286822010-03-08T18:16:31.364+05:302010-03-08T18:16:31.364+05:30One of our readers, who is an experienced Product ...One of our readers, who is an experienced Product Engineer, has posed a good question. He wants to know how he may start database testing on his product.<br /><br />My response is as follows. Work on a problem usually starts by exploring the problem. Therefore, he should explore the requirements related to the databases used by his product. He may be able to get some of these requirements by examining the product requirement specifications. He may also want to check the following things that are common to databases:<br /><br />1. If the data in the database come from external sources, is all the necessary (all rows and all columns in the input) data loaded in the database?<br /><br />2. If he were to select any entity in his product, would he find all data pertaining to that entity in the database? <br /><br />3. Is there any data in the database that is never used?<br /><br />4. Is the database design easy to understand and enhance?<br /><br />5. What are the typical query execution times for the database on a given server configuration?<br /><br />6. Does each database object work correctly and with reasonable speed?<br /><br />7. Does the database promote data integrity? For example, by using table relationships.<br /><br />8. Can someone look at hidden data? For example, can a user view some hidden data in an indirect way (by executing a stored procedure for instance)?<br /><br />Next, he may want to identify the high priority requirements from the business point of view. He should create some test scenarios for the selected requirements.<br /><br />He would need access to the database management tool/ environment e.g. Microsoft SQL Server Management Studio, Oracle SQL Developer to set up and execute his tests. Some tests may be fairly straight-forward and some may be quite complex. Some of the tests may involve writing SQL queries, executing them and checking their results. Other tests may involve using automated testing tools with SQL queries. I am planning to write on specific database tests later on.Inder P Singhhttps://www.blogger.com/profile/05923580987480854491noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-66086390975830763742010-03-05T20:15:14.870+05:302010-03-05T20:15:14.870+05:30This comment has been removed by a blog administrator.customerspecificshttps://www.blogger.com/profile/04943730063634348089noreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-32159888775215850192010-03-04T09:41:55.045+05:302010-03-04T09:41:55.045+05:30Inder,
Good article and very informative.Inder,<br />Good article and very informative.shivajinoreply@blogger.comtag:blogger.com,1999:blog-3806208351698608392.post-26916544824094937212010-03-04T01:59:27.842+05:302010-03-04T01:59:27.842+05:30Inder good post.
I have developed a database test...Inder good post.<br /><br />I have developed a database testing framework that can be used to carry out the types of tests outlined in your post.<br /><br />Details on where to download and how to use can be found here - http://wp.me/PFbM0-4aMichael Baylonhttp://michaelbaylon.wordpress.comnoreply@blogger.com