Ivar wrote:
Hi,

Each SAP Db is running as service, is it ood idea ?
Eg. for large number of databases it's problematic (Messes up win service
list and hard to manage).

Many DataBase servers conatains over 100 small databases.
You really shouldn't do that. You'r emuch better off rethinking your configuration. The manual explictily recommends against putting more than one database on one server.

I had a similar problem to you when I migrated from a PostgreSQL setup where I had a lot of databases to SAP DB. With SAP DB I made what had originally been a database into a user instead. Each user has its own default name space and because of this, their tables won't collide.

Hope this helps


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to