Topic: Database Test Automation

Message

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?

Author	Message
sapna Newbie Joined: 23Apr2007 Online Status: Offline Posts: 1	Topic: Database Test Automation 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? Post Resume: Click here to Upload your Resume & Apply for Jobs

	IP Logged

Abhijit Newbie Joined: 23Apr2007 Online Status: Offline Posts: 21	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?
	IP Logged

cprasenjit26 Senior Member Joined: 14May2009 Location: India Online Status: Offline Posts: 151	Posted: 18May2009 at 1:53pm
	ThePamie XML Demo shows how you can use Pamie and parameterize your test data by using XML files. Software testing tutorial
	IP Logged


One Stop Testing Forum : Types Of Software Testing @ OneStopTesting : Automated Testing @ OneStopTesting