> default name space and because of this, their tables won't collide. It makes hard to host DataBases.
Eg. I need to host 50 copies(each has for different company) of my DataBase. Why SAp Bd is messed with namespaces, why there isn't Databases as other DB servers. I think thats big missing part. > Each user has its own > default name space and because of this, their tables won't collide. Can two users share namespace ? "Elias Martenson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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
