Generating XML files from a database

[Dominic Feron]

Hello everyone,

Here is the situation. I've looked all day about this subject over the net
and I'm kinda confused...

I was ask to generate, on a daily basis, some XML files from a SQL Server
2000 database.

What is the best strategy to perform such a task?

I was looking foward using the DTS package within SQL Server but it doesn't
seem to have any function that could help me there. I also looked in the
direction of programming SQL Server Stored procedures but didn't found any
great solutions...
Should I write a .NET application that request the data from the server
then, create the XML file manually?

Or could you informe me of some kind of utility that could help me perform
this task?

Thx for the help!

[Robbe Morris [C# MVP]]

Depends on your needs. Using .NET is fine. If you want
to generate it right out of the database, SQL Server can handle this
as well:

http://www.eggheadcafe.com/articles/20030804.asp

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net

"Dominic Feron" <do***********@dessausoprin.com> wrote in message
news:e7**************@TK2MSFTNGP14.phx.gbl...

Hello everyone,

Here is the situation. I've looked all day about this subject over the net
and I'm kinda confused...

I was ask to generate, on a daily basis, some XML files from a SQL Server
2000 database.

What is the best strategy to perform such a task?

I was looking foward using the DTS package within SQL Server but it
doesn't
seem to have any function that could help me there. I also looked in the
direction of programming SQL Server Stored procedures but didn't found any
great solutions...
Should I write a .NET application that request the data from the server
then, create the XML file manually?

Or could you informe me of some kind of utility that could help me perform
this task?

Thx for the help!

[Dominic Feron]

Thx for the info!

But I think I found another way..

Our company just bought Reporting Services for Microsoft SQL Server. It is
possible to generate a reports then export the result in XML. It is even
possible to schedule these kinds of tasks!
"Robbe Morris [C# MVP]" <in**@eggheadcafe.com> a écrit dans le message de
news:u0*************@TK2MSFTNGP15.phx.gbl...

Depends on your needs. Using .NET is fine. If you want
to generate it right out of the database, SQL Server can handle this
as well:

http://www.eggheadcafe.com/articles/20030804.asp

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net

"Dominic Feron" <do***********@dessausoprin.com> wrote in message
news:e7**************@TK2MSFTNGP14.phx.gbl...

Hello everyone,

Here is the situation. I've looked all day about this subject over the net and I'm kinda confused...

I was ask to generate, on a daily basis, some XML files from a SQL Server 2000 database.

What is the best strategy to perform such a task?

I was looking foward using the DTS package within SQL Server but it
doesn't
seem to have any function that could help me there. I also looked in the
direction of programming SQL Server Stored procedures but didn't found any great solutions...
Should I write a .NET application that request the data from the server
then, create the XML file manually?

Or could you informe me of some kind of utility that could help me perform this task?

Thx for the help!

[Robbe Morris [C# MVP]]

Hmmm. should have mentioned your desire to create reports.
ActiveReports.NET from http://www.datadynamics.com is an
extremely powerful product. Probably a lot cheaper too.

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net

"Dominic Feron" <do***********@dessausoprin.com> wrote in message
news:Ot**************@TK2MSFTNGP10.phx.gbl...

Thx for the info!

But I think I found another way..

Our company just bought Reporting Services for Microsoft SQL Server. It is
possible to generate a reports then export the result in XML. It is even
possible to schedule these kinds of tasks!
"Robbe Morris [C# MVP]" <in**@eggheadcafe.com> a écrit dans le message de
news:u0*************@TK2MSFTNGP15.phx.gbl...

Depends on your needs. Using .NET is fine. If you want
to generate it right out of the database, SQL Server can handle this
as well:

http://www.eggheadcafe.com/articles/20030804.asp

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net

"Dominic Feron" <do***********@dessausoprin.com> wrote in message
news:e7**************@TK2MSFTNGP14.phx.gbl...

> Hello everyone,
>
> Here is the situation. I've looked all day about this subject over the net > and I'm kinda confused...
>
> I was ask to generate, on a daily basis, some XML files from a SQL Server > 2000 database.
>
> What is the best strategy to perform such a task?
>
> I was looking foward using the DTS package within SQL Server but it
> doesn't
> seem to have any function that could help me there. I also looked in
> the
> direction of programming SQL Server Stored procedures but didn't found any > great solutions...
>
>
> Should I write a .NET application that request the data from the server
> then, create the XML file manually?
>
> Or could you informe me of some kind of utility that could help me perform > this task?
>
> Thx for the help!
>
>