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.
28 freelancers are bidding on average £208 for this job
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
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.