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
Hi AntonioThanks for the above information. But I think this will come handy when one wants to deploy the reports to the reporting server. But in my case, i want to deploy the reports in the "Custom Reports" section of the "SQL Server Management Studio" from command prompt. Can i do that?Thanks in advanceSalil
For SQL Server Reporting Services, the SQL Server Managerment Studio is only a GUI tool that used to manage the Report Server too.
All reports are deployed to the Report Server.
AntonioCH's solution should work. After deploying the reports to the Report Server, you will find the reports in the SQL Server Managerment Studio.
Any more questions, please feel free to ask.
Jin Chen - MSFT
Hi Jin Chen,But the in built reports that are there in the SQL Server Management Studio are still visible if Reporting Server is not available. Therefore, i think we can still deploy the reports using Management Studio even if Reporting Services are off. Correct me if i am wrong.ThanksSalil