-
Junior Member
backend testing
How do we do backend testing.Whatelse do we need to know apart from basic SQL.Do we write SQL statements in the test cases, if so where do we write in TD or QC.Do we use CREATE and UPDATE statements for backend testing.I need this for my interview.
-
Junior Member
Re: backend testing
hello all,
I am intersted in software testing and working as a traniee
-
Junior Member
Re: backend testing
How do black box tester do testing of database migrated from sql to oracle
-
Expert Member
Re: backend testing
Hi Bhupender,
Welcome to the World of Testing - Database Specific
Well testing dB Migration would generally not be covered as part of a Tester's scope. There is a seperate team that looks into Migration projects....
But still if Insistent.....
We could write Automated Scripts which would Compare Table Structure of both the Databases once Migrationis complete. A simple workaround would be to Describe both the table structures in the DB's and take the output to Excel Sheets. We could parameterize DB.Table Name to achieve easier use.
Once the column names are in Excel, a simple Macro program to compare Range of values specified in both columns would suggest if the table was migrated successfully or not.
NOTE : But even then verifying Datatype of columns would not be possible.
Also checking Data Integrity would not be a part of the scope as well..
Cheers.......
-
Contributing Member
Re: backend testing
Hi Ayodhya,
In QC we can do backend testing in SiteAdmin.We use SQL statements for customization.We write queries in Tables.we have different tables for different modules in QC.For egfects module will have Tables like BUG,BUG TOKENS.Each table will have number of columns like BG_BUG_ID which is an integer type.
When we want to change the defect id then we go for SiteAdmin BUG table and will write Query "update sequences set SQ_SEQ_VALUE='1' where SQ_SEQ_NAME='BUG' ".This query results in changing the existed defect id in defects module starts with one...then the next defect ID will be two....and so on.
If you have any doubts then can get back to me any time as iam working as QC Admin...hope this information is useful for you.
Thanks
Deepika.P
-
Banned
Re: backend testing
hi dear
we do testing with nunit...
http://weblogs.sqlteam.com/mladenp/a...2/15/4165.aspx
Go with the flow & have fun! Else fight the flow
Thanks and regards
PRATAP M
-
Junior Member
Re: backend testing
back end testing is to verify data are available that was feed at user interface.
Data are the most valuable asset of the any company.
-
Junior Member
Re: backend testing
hello all,
I need some help to learn more about back end testing, pls send me some links and suggestions to develop my skills more on back end testing.
-
Junior Member
Re: backend testing
Hi i need Test Director & Q.C FAQ's. can u provide me a Download of FAQ's
-
Junior Member
Re: backend testing
If you are going for Manual then you can write your queries in the qc itself b'coz there is sql add-in . so all you need to do is configure your sql in qc there you may get a screen to write your queries only if your connected with the database only
-
Junior Member
Re: backend testing
You have discussed some interesting topics about backend testing. Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules