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
