This is an excellent questions as I too want to house several databases on the same server.
-----Original Message-----
From: Martin Cordova S. [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 1:34 PM
To: [EMAIL PROTECTED]
Subject: Multiple database instances per server?
Hi, I am a former MS-SQLServer user. When using SQLServer, I used to have
multiple databases hosted by a single database server, which is represented
as a single system service.
In SAPDB, each database is a service, so I wonder how should I parcel my
sets of tables (schemas), since I no longer have the database concept in the
way that SQLServer uses it. I know that SAPDB 7.4 does not have schemas
(right?), and I read somewhere in the SAPDB docs that it is not recommended
to have more than one database instance per server, so my question is:
Should I use the User as the schema equivalent, and create tables for
different businesses using a different user for each "business". I want to
use a single database instance to store tables for different (and unrelated)
applications, but I don't have a clear picture about how to create a
boundary between these tables.
Any help will be very appreciated and IMHO, such material should be a part
of the "SAPDB database concepts" section in the docs. It's kind of difficult
for an open source project to attract new users without more user friendly
docs, I suspect that many new users will come from the
MS-Access/MS-SQLServer world.
Regards,
Martin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
