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.

hello all,
I am intersted in software testing and working as a traniee

How do black box tester do testing of database migrated from sql to oracle

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.......

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 eg:Dfects 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

hi dear

we do testing with nunit...

[url]http://weblogs.sqlteam.com/mladenp/archive/2005/02/15/4165.aspx[/url]

Go with the flow & have fun! Else fight the flow


Thanks and regards
PRATAP M

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.

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.

Hi i need Test Director & Q.C FAQ's. can u provide me a Download of FAQ's

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

You have discussed some interesting topics about backend testing. Thanks.