SQL Server Import/Export

IN PROGRESS
Bids
23
Avg Bid (GBP)
£200
Project Budget (GBP)
£20 - £250

Project Description:
We require an application to allow us to backup and restore portions of our multi-tenanted database.

The database is an ecommerce system used by multiple websites, each with their own set of records. At the topmost level is a Website with a WebsiteID, below this are other tables, for instance Products, Categories, Orders etc (over 50 tables).

We need to be able to define a single Website to be backed up, possibly to a staging database. All related tables must also be included (Orders, Products, Stock etc. etc.). The relationships should be inferred through foreign key relationships, so that if new tables are added these are automatically included in the backup. Likewise, if new columns are added these should also be included in the backup file without the need to change the source code.

When restoring the data back it is assumed that the schema of the table would not have changed since the backup was made – if it has then the backup will not be restored (we will invalidate them).

If the schema has not changed then it should be possible to restore the backup from the staging database, including all of the relationships. The destination Website would be deleted (if it already exists) and replaced with the backup, there is no need to merge the data into an existing Website. It is vital that the relationships are maintained, so if in the backup and Order with and OrderID of 1234 is made, and it has two products with IDs of 345 and 678 then when restored the Order should still have the same two related products, although the IDs will have changed. This functionality will allow us to merge blocks of related data from several databases into another single database, so IDENTITY_INSERT cannot be used.

Skills required:
.NET, C# Programming, Database Administration, SQL
Hire carlwright
Project posted by:
carlwright United Kingdom
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 220
in 20 days
£ 250
in 15 days
Hire aarrsoftware
£ 240
in 25 days
£ 150
in 2 days
Hire shadowdancerlv
£ 250
in 7 days
£ 250
in 15 days
£ 250
in 20 days
£ 200
in 5 days
Hire ajay192
£ 450
in 10 days
£ 200
in 30 days