SQL 2005 import export wizard, where is the XML option, if not there how do i do it....?

I have a number of tables I need to output, no format changes, no row changes just a simple output to xml, i have the SQL server Server Import & Export wizard open but cannot find an XML option.... Am I missing something...? If not how on earth does one do it. I am an SQL novice and an even bigger XML novice...
HolmeRoseAsked:
Who is Participating?
 
RiteshShahConnect With a Mentor Commented:
this command will give you result in XML, you can use that in BCP to get file save in your disk.

SELECT *
FROM AdventureWorks.Person.Contact
WHERE LastName LIKE 'A%' ORDER BY LastName, FirstName
FOR XML AUTO, TYPE, XMLSCHEMA, ELEMENTS XSINIL
0
 
HolmeRoseAuthor Commented:
Hi there, many thanks for this. I have added my own query text and run it in Studio but it keeps crashing as it runs out of memory. The table has over 170,000,000 records. Can I dump it direct to an XML file..?

Where do I find the BCP - I am a bit of a novice and have never stepped out of SQL Studio....

0
 
RiteshShahCommented:
well BCP is not an issue, you have to run it in DOS mode but the main thing right now is that, you won't be able to dump all those records together in XML, you have to make small chunk and export it.
0
 
HolmeRoseAuthor Commented:
Why can they not be in one record...? There is plenty of drive space (over 2TB on my data drive and plenty of RAM 8GB)
0
 
RiteshShahCommented:
only hard drive and RAM are not the factor, so many other things also affects it, your log size, your processor's capacity etc.
0
All Courses

From novice to tech pro — start learning today.