• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using Excel to generate test data for Sql tables

 
Ida Achi
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I just need a direction, ideas on how and where to begin.
I need to use Excel to write test cases for a database with several tables. What should I be looking for?
For instance can I write test data in excel for table below? Please help. Thanks



- Table `viterra`.`partner`
-- -----------------------------------------------------
 
Lester Burnham
Rancher
Posts: 1337
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What role would Excel -or Excel files- play in this scenario? Are you using JUnit with something like DBUnit or SQLUnit?
 
Ida Achi
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
All I have is a MySQL database with a couple of tables. I need to use Excel to generate test cases ( stored procedure test, type test, data size test, input verification) for the database. No Junit or SQL unit.
Is this even possible?
 
Lester Burnham
Rancher
Posts: 1337
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The question was really: why do you need to use Excel? What particular features does Excel have that help with DB testing? Or, to put it in yet another way: How do you intend to test the DB with whatever data/information ends up in Excel?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic