April 21, 2008 at 4:15 am
I have 5 SQL Servers and totally around 100 databases (1 database for 1 client). Whenever I finish a Report development on my development server, I will need to repeat the same task on these 100 databases 100 times ?
Although I can copy the Report Definition File from the development server to these 100 databases' folders, I still need to do the following tasks :
(1)Create 100 new Visual Studio projects
(2)Enter "Start Item" and "Target Server URL" 100 times
(3)Create 100 new Shared Data Sources
(4)Build and Deploy Visual Studio projects 100 times.
Are there any better or more efficient ways to deploy a new Report in a multiple servers or multiple databases environment ?
Please help me.
Thanks a lot.
April 22, 2008 at 8:16 am
Check out the tools at redgate or make your own. There are SQL DMO objects you can use in .NET. you can probably create a simple tool to loop through your databases and sync the objects. let me know what you end up doing.
April 22, 2008 at 8:33 am
hello, I believe you have two options. You could use the Reporting Services Scripter utility "RS" to script out your different servers and publish them, or follow this link for this RDL deploy UI that uses SSRS web service just like .RSS sample in MSDN.
http://blog.hundhausen.com/PermaLink,guid,175e6eff-be6e-4838-8199-fc27974d3fcd.aspx
April 22, 2008 at 8:53 am
So are these client databases dispersed across several servers as well ? You may want to look at using SSRS script to deploy to multiple report servers. If the database is on the clients machine maybe you can look at SSRS client reports. I think the difference is that the RDL is run client side as opposed to on the server. The extension on this type of report is RDLC from what I remember.
If the environment is distrubuted I imagine you can put a list of servers in a file and then use a SSRS script to drive the deployment. It seems like there is very little documentation of this language but it seems like VB from what I can guess.
hth
Frank
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply