Fast Import/Export of XML data into a Microsoft SQL Server database

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.

Also I have had a look at bcp which appears to offer some support for XML,
but I have been unable to get it to do what I want. I would be interested to
know if there is a way to get bcp to work with XML data in the way I
describe.


.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
Loading