Deploying SSRS on SQL Server via tfs

Asked Aug 29 '17 at 13:18

Active Mar 02 '18 at 01:41

Viewed 325 times

0

I want to deploy a SSRS project from a TFS server to another server (ProdServer) as a job in SQL Server and run it dynamically.

How I can do it please.

edited Mar 02 '18 at 01:41

aduguid

3,099
6
18
37

asked Aug 29 '17 at 13:18

Hamdy

430
1
6
19

what do you mean dynamically? the dumbest way I could think of is to add all the TFS SSRS reports to your local project, then deploy that project to target server – LONG Aug 29 '17 at 13:25
actually i want to schedule TFS to deploy every night the work done during the day. – Hamdy Aug 29 '17 at 14:22
Which version of TFS are you using? – James Reed Aug 29 '17 at 15:33
I am using TFS 2015 – Hamdy Aug 29 '17 at 15:53

1 Answers1

1

You can try to write Batch script or use utility such as RS.exe to deploy the report, then in TFS Build definition call the script or utility.

Write script to deploy the report, reference this article. For Utility reference this thread: Reporting Services Deployment
Create a Scheduled build definition and add the step BatchScript/Command Line/PowerShell to call the script/utility

Below threads also for your reference:

answered Aug 30 '17 at 03:22

Andy Li-MSFT

28,712
2
33
55

Thank you for your reply. This is new form me working on scripts. I will notice if I succeeded. – Hamdy Aug 31 '17 at 09:47