We are going to sell a service that will be hosted by us, and for each customer Your database will be, but will be a centralized website. At present I have a blank database with some things that will require a new customer, what is the best way to copy this database, so can I set up another client? I want to be able to do this from an .aspx page. thank you in advanced!
Update: By the .aspx page, I mean that I should be able to kick the process from an .aspx page.
Update 2: We are running SQL Server 2008.
Update 3: Refers to Cade Roux's answer ... Thanks for a great reply, but ... what is the reason for dissolving all the databases in one, and then based client based On each identifier in each table? Will not it be difficult to completely architecture of the whole product? I would have to add these Client ID columns in practically every table, and DAL will need to know which client is looking for data with the current setup, I just exclude the connection string in DAL, it decides That's what the user is using on that site. In this way, after the connection string is set up, I do not have to worry about finding client specific data! How do these approaches compare (and I should add it as a separate question?
There is something different option:
You can separate your blank database, then when a user signs up, copy that database and mount it under a unique name for yourself and your master Map your account in the database.
Scratch using a scratch They can create a database and can script any base data online from the online template database or scripting the base data and map them to your account in your master database.
You should seriously request a multi- Consider going to the tenant architecture where all users are in the same database (to separate the customer ID column data with the most tables) If you are a few dozen That's going to be a customer.
Your notes about option 3 - this depends on your application. Retrieving multi-tenant can be difficult. On the other hand,
I think there are past stack overflow questions about this time:
I will call them with multi-tenant-DB or some things Anyhow, I think it's about a special tactic Comes in the form of a secondary idea for the answer, which shows the importance of involving the details of your overall goals in the strategy in each question on the stack overflow.
Comments
Post a Comment