SQL Server Import/Export with XML

CANCELLED
Bids
30
Avg Bid (GBP)
£201
Project Budget (GBP)
£20 - £250

Project Description:
We require a Stored Procedure, SSIS package or .NET c# class to enable our database to be exported to a single XML file (there are about 50 related tables). The export must contain all related data as sub nodes.

We require this work to be completed so that we can enable the backup/restore of sections of the database. We have a multi-tenanted database and it is required that we are able to move chunks of data (and all related data) from one server to another. The code should not have an adverse effect on the performance of the database and should not incur any database locking or excessive disk IO.

For example, we have an Orders table and a OrderLines table. There are one or many OrderLines for each Order. The exported XML must contain all data and all related data as sub nodes.

It should then be possible to import the data back into the database while still retaining the relationships (although new keys will need to be created with the correct relationships). This is very important.

The completed work should allow us to add new tables and columns without the need to alter the code to accommodate the change. It should be able to determine the database schema and correctly create the XML file.

Skills required:
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.


£ 200
in 1 days
£ 250
in 15 days
£ 250
in 2 days
Hire expertcoder1vw
£ 199
in 2 days
£ 200
in 5 days
Hire garygoog
£ 150
in 15 days
£ 250
in 7 days
Hire NehaliAmin
£ 150
in 3 days
£ 145
in 3 days
Hire mickeyht
£ 150
in 2 days