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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Administration » Would like script to deploy .sql and SSRS...

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

Rate Topic

Display Mode

Topic Options

Author

Message

computer.mike

Posted Wednesday, October 31, 2012 7:52 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, February 22, 2013 8:48 AM
Points: 33, Visits: 154

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

Koen Verbeeck

Posted Wednesday, October 31, 2012 8:07 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:30 AM
Points: 9,410, Visits: 6,495

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 »

Permissions