SQL Server Import/Export with XML

This project received 30 bids from talented freelancers with an average bid price of £201 GBP.

Get free quotes for a project like this
Project Budget
Total Bids
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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online