Andrea,
Where do we start here? OK, First off I'm not a SYBASE fan. Third
party's are dropping support rather quickly (PeopleSoft does not support
it any longer) and it's market share is dropping. Sooner of later I
think it will belong to one of the three giants to remain , IBM,
Oracle, or MicroSoft. SO I don't think that's such a great idea. Now
if your going to do it in Oracle, where is the bulk of your DB's right
now. If their on NT then go there. If their on Unix then go there.
Lastly I would NOT build a seperate instance for every trainee. That is
ludecrious. Now a seperate schema for each would be more reasonable,
but enev then the kernel load to merge all of that data back toghether
for her perusal is WAY TOO much. In this case your Trainer is the
customer. She should be laying out what her requirements are. Sha has
done that by saying she needs a training database and that she wants
each trainee to see only their records. OK, now it's up to her to leave
the rest to you. If she can't do that, if she MUST DICTATE the
solution, then my answer is "Your on your own, go away and don't bother
me."
Dick Goulet
---------------------- Reply Separator ----------------------
Author: Andrea Oracle <[EMAIL PROTECTED]>
Date: 4/27/01 10:00 PM
Hi all,
Our trainer needs to build training database/s, she is
asking the following questions:
1. use Sybase or Oracle as the database server?
We have some projects using Sybase databases, and
old training database is on Sybase.
2. build the database on Unix vs NT platform?
3. She wants each trainee has his/her own
database(!!!), since she doesn't want one use to see
other user's data. And she said in Sybase it's really
easy to do this, she has a script that can create
multiple databases. Is it doable (please give some
tip or script), or is it necessary ???
Any idea will be greatly appreciated!!!
Andrea
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrea Oracle
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).