| What is test database ? [message #121222] |
Fri, 27 May 2005 00:09  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Can any one define me test database ? pls dont send me doc on it i just need simple defination of what is test database ? Is there are any live data on test database or it is just database for testing purpose and RND of DBA?
From :- sunilkumar mishra
|
|
|
|
|
|
| Re: What is test database ? [message #121353 is a reply to message #121269] |
Fri, 27 May 2005 14:21  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Please consider RND as R&D in above question ....
I am sorry for that miss typing of R&D as RND.
By the way my quetion is as it is
[1]what is test database ?
[2]Is there are any live data on test database or it is just database for testing purpose and R&D of DBA?
From:- sunilkumar
|
|
|
|
| Re: What is test database ? [message #121447 is a reply to message #121353] |
Sun, 29 May 2005 13:31 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
[1]what is test database ?
Database created for simulating ur production setup in a testing environment.
[2]Is there are any live data on test database or it is just database for testing purpose and R&D of DBA?
When u r creating a test database, either u can have it restored from backup copy of production database, or u can can create it from scratch. In first case, database will be containing data uptil point of backup of production database. But since, this database is for testing purpose, u can't call this data live.
Beware: u should not play around with ur live production database. Do all testing activities first on test server and then implement them on production server, ofcourse after taking note of all observations on testing server.
|
|
|
|
| Re: What is test database ? [message #121454 is a reply to message #121447] |
Sun, 29 May 2005 23:28 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Thanks girish for your reply and .... by the way if I import my data from live database to my local server and do R&D on it that means i had created test database? (i.e. by migrating database on same version of o/s and oracle) sir please, Answer me in yes or no.
From:- Sunilkumar Vishwanth Mishra
|
|
|
|
| Re: What is test database ? [message #121455 is a reply to message #121222] |
Sun, 29 May 2005 23:40 |
DMcG
Messages: 51
Registered: May 2005
Location: Auckland, New Zealand
|
Member |
|
|
A test database is simply a database you use to test your application on before using it in a live environment. It can be a different version of Oracle running on a different operating system with a completely random set of data, but if that's what you test on, then that's your test database (admittedly not a terribly good one).
The closer your test database mimics your live one then the more likely you are to catch application bugs before you go live. Ideally, use another system with the same version of OS and Oracle and with either a subset or better still, a super set of your live data.
Dougie McGibbon
|
|
|
|
| Re: What is test database ? [message #121468 is a reply to message #121455] |
Mon, 30 May 2005 01:15 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Thanks girish for your reply and .... by the way if I import my data from live database to my local server and do R&D on it that means i had created test database? (i.e. by migrating database on same version of o/s and oracle) sir please, Answer me in yes or no. From:- Sunilkumar Vishwanth Mishra
Yes
Well Sunil, I hope DMcG's reply does answer ur query in detail..
The closer your test database mimics your live one then the more likely you are to catch application bugs before you go live. Ideally, use another system with the same version of OS and Oracle and with either a subset or better still, a super set of your live data.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
