Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
salilguptasg@gmail.com
Starting Member
3 Posts |
 Posted - 2009-09-22 : 09:26:10
|
| HiHow can i deploy an RDL file to SQL Server Management Studio from command prompt. I have deployed that file using the GUI from the management studio but for automating the process, i want to deploy that RDL file from the command prompt.Kindly let me know whether we can do this from command prompt and how?Thanks and regardsSalil |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-22 : 09:43:48
|
| This may be what you are looking for.Article about Publishing Report Definitions with both VB and C#http://msdn.microsoft.com/en-us/library/aa337428(SQL.90).aspxJohn"The smoke monster is just the Others doing barbecue" |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2009-09-22 : 12:48:53
|
| Is it really SQL Server Management Studio that you want as the target for your report? Are these reports that you want to show up in the Custom Reports area of the right-click menu?Or are you intending to deploy these to a Report Server? If deploying to a Report Server from the command line, you can build a .rss script that uses the RS.exe to do this. Check Tara's blog entry http://weblogs.sqlteam.com/tarad/archive/2005/01/05/3944.aspx--------------------------------------------Brand yourself at EmeraldCityDomains.com |
|
|
|
salilguptasg@gmail.com
Starting Member
3 Posts |
Posted - 2009-09-23 : 06:01:47
|
| Hi AjarnMarkI dont want to deploy my reports to ReportServer. My target is "Custom Reports" section in the SQL Server Management Studio. Can we automate the deployment of reports for that?Thanks in advanceSalil |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2009-09-23 : 18:29:56
|
| I imagine there would be. I think there is a Micrsoft Installer approach that works, so I would guess that there is a pure command-line way to do it, but I haven't done it myself. I'd do a search on MSDN, there should be something out there for it.--------------------------------------------Brand yourself at EmeraldCityDomains.com |
|
|
|
|
|
|
Deploying RDL files to Management Studio from comm