Accessing FTP site from sql server

How to create DTD compatible XML file from result set returned from a query.

Can we access FTP site and upload this xml ?

Is it possible to do from Tsql?

I suggest that you might use CLR stored procedures to accomplish what you desire. You can write C# code to extend the functionality of SQL Server and have the client call a custom stored procedure to execute that C# code. This should enable you to populate a document in any format from data stored in the server and connect over FTP to upload the file.

Hope this helps,

John

|||

http://msdn2.microsoft.com/en-US/library/aa197263(SQL.80).aspx

Maybe this site can help you with witing the extended store procedure to accomplish what you want to do.
Please that DTD is deprecated , you may want to look into using XSD.

Accessing FTP site from sql server

How to create DTD compatible XML file from result set returned from a query.

Can we access FTP site and upload this xml ?

Is it possible to do from Tsql?

I suggest that you might use CLR stored procedures to accomplish what you desire. You can write C# code to extend the functionality of SQL Server and have the client call a custom stored procedure to execute that C# code. This should enable you to populate a document in any format from data stored in the server and connect over FTP to upload the file.

Hope this helps,

John

|||

http://msdn2.microsoft.com/en-US/library/aa197263(SQL.80).aspx

Maybe this site can help you with witing the extended store procedure to accomplish what you want to do.
Please that DTD is deprecated , you may want to look into using XSD.

Access Remote SQL SERVER

Hi :)

Is there a way that i can use to connect to SQL SERVER of my WebService Provider ??

I mean how do i upload my database to the SQL SERVER of my WebService Provider ?

ThanksIf the ISP has allowed you to (by opening port 1433) you can.

Otherwise, you should check with the ISP to see how they suggest uploading databases.|||Thanks for the reply :)

They have given me the port number witch its not 1433 ..its another one ...but what software could i use ...i mean a manager ...i have some trials instaled ...but on the connection option theres no place for the port number ...

is there a correct way to do the connection ?

Thanks|||You can use Enterprise Manager. If you have the SQL Server client installed, there is a Client Network Utility that will allow you to set a port for the connection. Without the SQL Server client installed, I am not sure how the other tools you may have work. I would pick up the SQL Server developer's edition, which I think sells for US$40.00 or so.