Dynamically changing database connectio

4 posts by 4 authors in: Forums > CMS Builder
Last Post: October 15, 2012   (RSS)

By vl4899 - May 16, 2012

I would like to use the same codebase for a number of clients, but rather than having separate instances of code and database, I'd like to use one code base and multiple databases. How could I switch between databases dynamically?

Volodymyr

Re: [vl4899] Dynamically changing database connectio

By ispro - October 4, 2012

I have a atandard web application that I sell to clients. The problem is that whenever I make a code change, I have to replicate it across every client. I would like the application to work like a cloud app, where the code base is common, but the databases depend on the domain or user signon. I am perfectly prepared to pay a license fee per client. My far bigger desire is to only update one code base.

Volodymyr

Re: [ispro] Dynamically changing database connectio

By Jason - October 15, 2012

Hi Volodymyr,

Currently CMS Builder doesn't support this type of configuration. One approach, if all your clients were on the same server, is to have common functions that are included on all of your client pages. You can then use local CMS Builder functions to retrieve records, these records could then be passed to one of your common functions for manipulation if required.

Hope this helps,
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/