Re: XSD schema SQL Server Profiler exports

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Thanks a lot, was verry helpful! Generating an XSD from an XML file is never
as good as the original XSD :-)

"Bob Beauchemin" wrote:

Hi Bjorn,

They live in Microsoft SQL Server\90\Tools\Profiler\TraceDefinitions or
Microsoft SQL Server\100\Tools\Profiler\TraceDefinitions if you have SQL
Server 2008.

Cheers,
Bob Beauchemin
SQLskills

"Bjorn" <Bjorn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5C90D755-19D1-41C3-B2AC-CE200B56FEFF@xxxxxxxxxxxxxxxx
Hi,

After taking a trace with SQL Server Profiler, it is possible to export
the
results of the trace to an XML file. Now I would like to write my own
analyzer tool in .NET, but I need the XSD schema for these XML files. Can
anyone provide me that or tell me where to find it?

Regards,
Bjorn


.



Relevant Pages

  • Re: XMLDesigner XSD DataSet Order with Relationships
    ... I don't suppose you could post your xsd schema? ... it looked like this in .Net's XMLDesigner: ... the Dataset.WriteXML command to produce the XML file. ... XMLDesigner puts the related tag at the bottom of the BankItem ...
    (microsoft.public.dotnet.xml)
  • Re: xsd.exe cannot generate schema
    ... xsd.exe cannot generate a schema from such an xml file. ... For example, write the XSD like ...
    (microsoft.public.dotnet.xml)
  • Re: How is this done?
    ... Why not have them open the XML file and then the program opens the XSD file ... I would like the XML and XSD to be a SINGLE file. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Writing an XMl file using a specified schema
    ... This is the xsd: ... the relation objects create the parent child relationship between the ... the columnmapping stuff is pretty self explanatory. ... data to a xml file, I want to map the XSD file I created to the dataset so ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: xsd.exe cannot generate schema
    ... thought it should be dealt with by default by any schema inferencing tool ... The reason I ask is that BizTalk makes a lot of use of xsd schemas. ... xsd.exe cannot generate a schema from such an xml file. ... >> The xml file has a mix of defined namespaces and also an empty namespace. ...
    (microsoft.public.dotnet.xml)