Sunday, March 25, 2012

Customer specific data backup (conditional backup)

We are planning to serve a web application on the Internet that customers will be signing up for, to use it.

The application is using SQL server database to store customer data. Same database and same tables will be used for all customers. Tables that store customer data (not system data such as country codes etc) will have a column, say, CustomerID that will indicate the record belongs to that customer.

Now we are looking for some sort of tool to allow us to backup a single customer's data and give it to them in case they ask for their data. For example, if Customer with CustomerID = 445 wants his data, we should be able to create a sql database that contains all records from all tables that have a customerID column, where the customerID = 445. If a table does not have customerID column we want to include all rows from such table.

I was wondering if such a tool (MS or third party) exists, or shall we create our own?

I appreciate your response.

You would create an SSIS package to do something like this.

No comments:

Post a Comment