More 2 the same is the name of the game

Testing software without changing the DB

How can we test our application, without manufacturing special DB version? Needless to say without revealing the real  operational data!


Would you like to answer or comment?

Sign up for a free account, or sign in (if you're already a member).
  • 735 views
Share Send to a friend Watch Report
 

Best Answer

 
2 thumbs up

There is a product that is able to change the information fields in the query and in the answer online without changing the query itself. If you are interested in this product feel free to send an email to ofer.goldhirsh@gmail.com and I will give you more detailed information about it.


Posted 2 years ago ( permalink )
In reply to Knowli's question
Rated as
Best Answer
0
2

Helpful?

line
line
line


 

All Answers

Order by
 
91 thumbs up

You're going to have to be a bit more explicit.  Are you worried about writing to the production database during testing?  If so, just suspend commits and do a rollback at the end of each test.  Are you worried about testers seeing confidential data?  If so, then you will either have to create a test DB (which is what it sounds like you're trying to avoid), or your testers will have to submit each test to someone who is authorized to be exposed to private data, and have that person run the test and provide the anonymous test results back to the testers.  Very slow. 



Posted 2 years ago ( permalink )
In reply to Knowli's question
Rated as
#2 out of 8
0
0

Helpful?

line
line
line



 
3 thumbs up
More 2 the same is the name of the game

Thanks

I was looking for a solution that will avoid the painfull process that u descibed so well!

There should be a way to do that unless u need to check the data itself!


Posted 2 years ago ( permalink )
In reply to gjbloom's answer
Rated as
#3 out of 8
0
0

Helpful?

line
line
line



 
3 thumbs up
More 2 the same is the name of the game

can u give us more details!


Posted 2 years ago ( permalink )
Rated as
#4 out of 8
0
0

Helpful?

line
line
line



 

I have heard about a box that is located between the developer segment and the database segment. The box is able to hide information and change the data on the fly. Using this box allows to give developers visibility to the production Database without jeopardizing the security and also allow testers to use a replica of the real database


Posted 2 years ago ( permalink )
In reply to Knowli's question
Rated as
#7 out of 8
1
0

Helpful?

line
line
line



 
3 thumbs up
More 2 the same is the name of the game

Can you give us more details?

Tnx

 


Posted 2 years ago ( permalink )
In reply to Herzel's answer
Rated as
#5 out of 8
0
0

Helpful?