Would like script to deploy .sql and SSRS files from a folder

• computer.mike

  Right there with Babe

  Points: 719

  More actions

  October 31, 2012 at 7:52 am

  #393507

  I used to have a .bat file script that would loop through a folder and execute my .sql files (for procedures, tables, functions, etc) and copy my .rpt files to the proper place also. I would set the server and database in the script and the directory for the .rpt file.

  Not that I am working with SSRS. Does anyone know a script that would basically do the same thing but also deploy my SSRS file to? Hopefully I could put all my files in a folder and choose the server, database and report server folder to deploy to.

  It could be VB script, sql script, and bat file or whatever. Looking for examples that I can customize for my enviorment.

  Thanks,

  Mike

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  October 31, 2012 at 8:07 am

  #1554612

  Check out Reporting Services Scripter:

  http://www.sqldbatips.com/showarticle.asp?ID=62

  It can script out everything from a given 2005/2008 environment.

  After it's finished, you can look at the resulting scripts to get an idea about the VB scripts.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP