Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Would like script to deploy .sql and SSRS files from a folder Expand / Collapse
Posted Wednesday, October 31, 2012 7:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 12:20 PM
Points: 33, Visits: 173
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.


Post #1379315
Posted Wednesday, October 31, 2012 8:07 AM



Group: General Forum Members
Last Login: Yesterday @ 2:09 AM
Points: 15,501, Visits: 13,163
Check out Reporting Services Scripter:

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.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1379328
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse