Print Page | Close Window

Database Test Automation

Printed From: One Stop Testing
Category: Types Of Software Testing @ OneStopTesting
Forum Name: Automated Testing @ OneStopTesting
Forum Discription: Discuss All that is need to be known about Automated Software Testing and its Tools.
URL: http://forum.onestoptesting.com/forum_posts.asp?TID=836
Printed Date: 19Jul2025 at 3:04am


Topic: Database Test Automation
Posted By: sapna
Subject: Database Test Automation
Date Posted: 23Apr2007 at 11:41pm
Hi,

We have been trying to figure out a best approach for creating an automated test harness to test database import and export functioanlity.

1. Import an xml file to the database and compare the data in database with the imported xml file to ensure that data has been imported successfully.

2. Export - Here an xml file is generated by running an export utility and we need to test that the data in xml file and the structure of xml file is generated as expected.

Can you please provide some directions on what would be the best approach to automate this kind of test harness?


Replies:
Posted By: Abhijit
Date Posted: 24Apr2007 at 3:54am
That is too much of an open ended question.

You need to consider information none of us will have available.

Things like:
  • What is the programming skill set in your department?
  • What is your infrastructure use? Are you already set up for a specific technology?
  • Are you wanting to bring in a thrid party end-user mimic tool, or are you wanting to do back end only?
  • Would a scripting language like PERL or PYTHON do what you need?
  • How indepth are you wanting to test? Could a simple in-code unit tester do the job, or are you looking to do full load/performance/etc testing?
  • If you only have those two items, listed as your test, what do you already have inhouse you can use with miniumal training or learning curve?

Posted By: cprasenjit26
Date Posted: 18May2009 at 1:53pm
ThePamie XML Demo shows how you can use Pamie and parameterize your test data by using XML files.
 

http://softwareqatestings.com - Software testing tutorial


Print Page | Close Window