CODEWITHSUNDEEP
sql-serverreporting-servicestfsssrs-2012
Hamdy
Hamdy

Reputation: 440

Deploying SSRS on SQL Server via tfs

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.

Upvotes: 0

Views: 389

Answers (1)

Andy Li-MSFT
Andy Li-MSFT

Reputation: 30372

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.

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

Below threads also for your reference:

Upvotes: 1

Related Questions