desmi
Newbie
Reged: 07/16/10
Posts: 2
|
|
I need to test an application that is created in MS-Access.
The company that uses the application wants to migrate the database from an Access database to MS-SQL database.
I have experience in testing webapplication (with jmeter) but I never tested a Access application.
Does anyone knows a good way to do this?
I came up with 3 ways to do a test:
1. Skip the Access GUI app and just use jmeter to fire database querys at the database
2. Record the network traffic and try to play it back
3. Use several (virtual) machines run the application on all of them and use a Macro to simulate users.
I dont really like these options so I really hope there is a better way.
Maybe its also good to say that this company doesn't have the budget for expensive tools like loadrunner.
Edited by desmi (07/16/10 02:29 AM)
|
Joe Strazzere
Moderator
Reged: 05/15/00
Posts: 10104
Loc: Massachusetts, USA
|
|
Quote:
I dont really like these options so I really hope there is a better way.
What don't you like?
Knowing that might help others suggest something that more closely fits what you do like.
-------------------- - Joe
I speak only for me. I do not speak for my employer, or for anyone else.
Visit my new blog All Things Quality
|
James Pulley
Moderator
Reged: 08/01/01
Posts: 4225
Loc: 22031, 28112 & 85711
|
|
Don't bother. Your scalability will drop off horribly at six users and end completely by the time you hit ten.
Get a dozen of your friends together and ply them with pizza and beer if you must test an Access based solution for scalability. It's not worth the investment of time and resources to automate a test like this with the scalability of the target so well known.
-------------------- James Pulley
Offsite, fixed price, defined deliverables, LoadRunnerByTheHour. Starting @ $19.95/hr USD.
Flexible Delivery-off-site & on-site, negotiated deliverables, Test Architecture and tools, Professional Services The ScriptFarm
Put us to the test, skilled expertise is less expensive than you might imagine.
|
desmi
Newbie
Reged: 07/16/10
Posts: 2
|
|
Quote:
What don't you like?
I like it if I make a simple testscript that people without much performance testing knowlegde can start and use.
I also like it if al the tests are the same so I can start the test and have a good way to compare different settings/versions etc.
|