-1

We've developed a Web Application using ASP.NET and Sql Server. We've started selling it and of course are still continue improving and developing it.

How do we go about updating each client's version of the site? We have, maybe, 50 customers. So 50 different folders and 50 different db's sounds like a bad idea. Is there any known method for solving this kind of scenario?

Some more detaials: we are developing a CRM, for 50 companies. They will have 10 users maybe. It makes 500 users and their customers and products.

Pierre.Vriens
  • 233
Muhammet Göktürk Ayan
  • 101

3 Answers3

4

If each customer has a separate copy that you regularly ship updates to, your application must be able to handle upgrades gracefully.

  1. Database versioning

    You must store the schema version in the database. Each time you change the schema, you have to include logic in an admin module so customers can upgrade the database (semi-automatically). Each version upgrade should be defined as an action, and upgrading across several versions means running the actions one after the other.

  2. Application versioning

    When you install new versions of the software, you have to provide a migration procedure. Sometimes this means that all customer changes must go into a special folder that is copied back into your software after upgrade. At other times it means you must make an installer that "patches" the installed copy.

Community
  • 1
Joeri Sebrechts
  • 13,002
0

The way you described that you have one application and its been used for several different clients and as you mentioned you have 50 folders and 50 databases it means you have the entire application on your server or one server probably.

If I get the descriptions correct then I would suggest you look into the Whitelable Solution for this application. check this link

You would have all the code in one place and one database {or you may use different if applicable}

hope this helps

Junaid
  • 222
0

Generally it is not possible to update each client version.

One solution is to provide updates as additional modules or plugins. So there is no need to modify the core.

It works in the case of php application called wordpress.

Wordpress cms is used to develop blog websites.

In wordpress you can add or remove plugins,which provides additional features.

pandu
  • 11