SQL Server Import/Export with XML

Cancelled

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: SQL

See more: export sql xml import sql server, sql server import export xml, import io, xml export, ssis sql, Sql ssis, sql server ssis, sql server 2012 ssis, net c# sql server, move sql, import/export, import sql, Import Export, sql created, net import export, data export net, xml database procedure, sql database import export, schema sql, xml class, sql server export import database, create tables sql 2012, ssis export xml table example, ssis package move server, sql move data

Project ID: #3977072

28 freelancers are bidding on average £208 for this job

eperfections

Being best database programmer, I can perform this task.

£200 GBP in 1 day
(70 Reviews)
5.9
sandeep25101982

Hi SQL SSRS,.Net C#. Proposal is for C# class. Thanks

£250 GBP in 15 days
(8 Reviews)
5.3
qualifiedcoders

Hi We have read your requirements.We have completed 80+ big asp.net,c# projects in last 5 years. Please check private message board for details.

£250 GBP in 2 days
(1 Review)
4.6
expertcoder1vw

Hi, I am an expert SQL Server / C#.Net developer & can do this job for you. I can start NOW! Regards, Larry A.

£199 GBP in 2 days
(10 Reviews)
4.5
kultech

I usually regularly work with winservices, webservices for the import, export from database to xml and back. I'm sure complete for you. Please check PM. Thank you

£200 GBP in 5 days
(4 Reviews)
4.4
garygoog

Please check PM.

£150 GBP in 15 days
(1 Review)
3.9
reechmeraj

Greetings!!! We are glad to bid on your project and would be more happy if get a chance to work on the same. Please see PMB for details

£250 GBP in 7 days
(5 Reviews)
3.6
NehaliAmin

Can do this.

£150 GBP in 3 days
(5 Reviews)
3.6
kushanx

I am an expert SQL developer. I can do a SSIS package or a small .net application to accomplish this exporting task.

£145 GBP in 3 days
(6 Reviews)
3.5
mickeyht

I have 10+ years of experience in developing T-SQL procedures for various purposes, and I am using it in my daily job. XML export is a part of the job, and I am ready to deliver the operational code to your full satis More

£150 GBP in 2 days
(3 Reviews)
3.1
ranju61

Hi I can provide you c# class which will do your job to export data to xml with parent child relationship

£70 GBP in 2 days
(3 Reviews)
2.5
narendragautam

Hi, I will use C# .Net application which will read your sqlserver database for creating the xml file. Could you explain about your database schema and xml formatting or mapping from database table. thanks Nare More

£250 GBP in 7 days
(1 Review)
2.5
grrigh

I am 7 year experience in Oracle, Pl/sql. I can finish your work in quickly time and good quality.

£150 GBP in 3 days
(0 Reviews)
0.0
imrul01

please check PM

£30 GBP in 0 days
(0 Reviews)
0.0
MastersMind

Our recent accomplishment for a local client is exactly similer to this. We delivered 55MB XML file. Sample : GTL_Rate S More

£175 GBP in 2 days
(0 Reviews)
0.0
SSSarel

I'm a Database and BI consultant. The project you described is part of my day to day work.

£50 GBP in 3 days
(0 Reviews)
0.0
Vicar

Hi, I would like to work on this project. Regards, Vicar

£20 GBP in 2 days
(0 Reviews)
0.0
ajay192

As a standard practice in our disaster management and data loss mitigation procedure, we build in codes in our software to periodically - Please see PMB for details.

£450 GBP in 10 days
(0 Reviews)
0.0
stellajn

Hi, Thanks for the opportunity to apply.

£250 GBP in 7 days
(0 Reviews)
0.0
shri270

hi, we are ready to provide you the demo of your complete requirement . that you have posted. please check private message

£150 GBP in 10 days
(0 Reviews)
0.0