Deploy SQL Reports to SQL Reporting Server? [Archive]

View Full Version : Deploy SQL Reports to SQL Reporting Server?

kblaine

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

06-19-2006, 07:51 AM

For which version of SQL Server?

kblaine

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

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

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/vsnetprojectsolutiontab.htm
http://msdn.microsoft.com/library/en-us/vsintro7/html/vxlrfDeploy.asp

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