Posts Tagged ‘XML’

The Citrix XML server explained and demystified

Written by Ingmar Verheij on August 16th, 2012. Posted in Citrix, Demystified, XenApp (Presentation Server), XenDesktop

The Citrix XML server is a component of Citrix XenApp and XenDesktop that’s used to enumerates available resources  and provide secure tickets for users that  to use the  WebInterface or CloudGateway.

 

In this article I’ll explain what the services the XML service provide, how it does it job and all you need to know about it.

Exporting data from SQL to XML

Written by Ingmar Verheij on May 8th, 2010. Posted in Batch

Exporting data from a SQL database to a XML file is very easy, if you know how to.
Using the bcp command (bulk copy program), a tool supplied by Microsoft, you can easily export all the data you want.
– Create a new text file and type the following text:

<root>
</root>

– Save the text file with a .xml extension, for instance data.xml;
– Open a new Command Prompt (as Administrator in Vista/Win7/2008 R2);
– Execute the following command : bcp.exe “SELECT * FROM Table AS XML RAW” queryout data.xml -c -r -t -T.
If you want to script the process with batch (we’re a big fan of batch files) you can use the following script:

@Echo Off

REM Create an empty XML file
ECHO ^<root^> >data.xml
ECHO ^</root^> >>data.xml
REM Export the data using BCP
bcp.exe "SELECT * FROM Table AS XML RAW" queryout data.xml -c -r -t -T.

Ingmar Verheij & Daniel Nikolic

Donate