October 31, 2012 at 7:52 am
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
October 31, 2012 at 8:07 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply