Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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.

Thanks,

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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:34 AM
Points: 13,551, Visits: 10,424
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.




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 LessThanDot.

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

Add to briefcase

Permissions Expand / Collapse