I want to be able to import and export large amounts of data from a SQL Server database using XML.
That is, I want the data exported in XML format, and the same data held as XML files to be imported back in again.
The important thing is that this needs to be very fast.
This needs to work for SQL Server 2005 and 2008.
There should also be no collation restrictions, so if I export from a database using one collation sequence, I can import into another database with the same schema but with a different collation sequence.
Through Google I have just come across this article http://support.microsoft.com/kb/316005
which talks about a SQL Server Build Load component. I am not familiar with this, but if anyone has any experience of it, perhaps they can confirm if it is what I am looking for and if there are any gotchas or limitations?
I should also add that some of the data is held in binary format, it isn't all varchars, numbers and dates.