Deploy SQL Reports to SQL Reporting Server?

[kblaine]

Can I automate Visual Build to deploy my RDL's (sql reports) to my SQL Reporting server? Please tell me this is possible!

thx.
-b

[kinook]

For which version of SQL Server?

[kblaine]

SQL Server 2003. I know Visual Studio can do it, just didn't know if Visual Build could. Would be GREAT if it can!! thx. -b

[kblaine]

SQL 2000. Sorry, my bad. 2000 is what we are using. We are about to bust out 2005, but not for a couple months.

[kinook]

If the VS.NET 2003 deploy action for reporting projects can be configured to deploy .rdl files, you can call that via a Make VS.NET action (Deploy/Publish build behavior):
http://www.visualbuild.com/Manual/vs...olutiontab.htm
http://msdn.microsoft.com/library/en...xlrfDeploy.asp

Other options:
1) Use a Copy Files or FTP action to deploy the files as needed.
2) http://www.codeproject.com/cs/databa...portDeploy.asp (this is for VS2005 but might work w/ older versions with a little modification)