I have a CRM written for my industry that I would like to rent to others on a SAAS basis.
Of course, everything between client companies must be kept separate.
- Do I need to install completely separate databases for each client, or can I separate the data and logic layers so that all I need to do is point to each client's data tables, respectively?
- If separate databases entirely, what is the best way to handle upgrades/versioning? I'd really NOT like opening 100 or 100s of client program to make one or a few tweaks at a time
Thanks in advance for any help.