Results 1 to 11 of 11

Thread: backend testing

  1. #1
    Junior Member
    Join Date
    Jan 2007
    Answers
    3

    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.


  2. #2
    Junior Member
    Join Date
    Dec 2007
    Answers
    2

    Re: backend testing

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


  3. #3
    Junior Member
    Join Date
    Dec 2007
    Answers
    2

    Re: backend testing

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


  4. #4
    Expert Member
    Join Date
    Oct 2007
    Answers
    375

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


  5. #5
    Contributing Member
    Join Date
    Feb 2008
    Answers
    59

    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


  6. #6
    Banned
    Join Date
    Oct 2007
    Answers
    173

    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


  7. #7
    Junior Member
    Join Date
    Aug 2007
    Answers
    1

    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.


  8. #8
    Junior Member
    Join Date
    Nov 2008
    Answers
    1

    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.


  9. #9
    Junior Member
    Join Date
    Mar 2009
    Answers
    1

    Re: backend testing

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


  10. #10
    Junior Member
    Join Date
    Aug 2011
    Answers
    3

    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


  11. #11
    Junior Member
    Join Date
    Nov 2015
    Answers
    17

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact