Deploy SQL Reports to SQL Reporting Server?

kblaine · #1 06-16-2006, 01:59 PM

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 · #2 06-19-2006, 07:51 AM

For which version of SQL Server?

kblaine · #3 06-19-2006, 07:58 AM

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 · #4 06-19-2006, 07:59 AM

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 · #5 06-19-2006, 11:17 AM

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)