Using custom Schemas for RBS tables....


Author
Message
Edhy Rijo
E
StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
It is possible to have the RBS tables use a custom Schema name instead of dbo?

The idea is to have one Database hosted online on my ISP and use a Schema for each project that will use this database, this way I would no need to have several databases online and use one common database for several small projects.

Ex:

  • FixTrack.SFSUsers
  • StrataFlix.SFSusers
  • AnotherProject.SFSUsers

Is this something that could be done with today's version of SF?

Are there any changes I would need to do to RBS to make this work?

Edhy Rijo

Reply
Edhy Rijo
E
StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)StrataFrame VIP (3.8K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Hi Dustin,

In my case and I am sure many others, the problem is that ISP charges per database and size of the database, not per table, and using schema seams like a nice approach to have a single online database hosting different small projects.

Honestly, do you think that this could be a realistic enhancement request? even though I am sure it could not be for 1.6 release Hehe, since it looks like the changes needed by the RBS would required using the BOM to change the schema used for the RBS per project or something along those lines.

Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search