|
|
You're in the
sql server reporting services
group:Deployment
sql server reporting services:
What is the best way to deploy a Reporting Services solution. The solution consists of database scripts, reports, CRI dll's and roles. Thanks Henrik
Hello Wei Lu,
We have a solution that contains the following elements: 1) SQL Scripts, which create views, tables, ect. 2) Custom Report Items (CRI) which is contained in a DLL 3) Reports (RDL files) 4) Reporting Services User Roles 5) Datasources 6) Setup of policies (permissions) on each report We have to package the solution and deploy it to multiple customers. Best regards Henrik. [quoted text, click to view] "Wei Lu [MSFT]" <weilu@online.microsoft.com> wrote in message news:OnGVeBD7GHA.2336@TK2MSFTNGXA01.phx.gbl... > Hello Henrik, > > I am not sure what does your solution include. > > Based on my research and experience, you need to deploy those data > seperately. > > For example, you need to run all the database scripts on the production > environment and then, you could use the VS 2005 IDE to deploy the report. > > I am not sure what did you mean CRI dll and roles. Would you please > specify > it more clearly? > > Sincerely, > > Wei Lu > > Microsoft Online Community Support > > ================================================== > > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues > where an initial response from the community or a Microsoft Support > Engineer within 1 business day is acceptable. Please note that each follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach the > most efficient resolution. The offering is not appropriate for situations > that require urgent, real-time or phone-based interactions or complex > project analysis and dump analysis issues. Issues of this nature are best > handled working with a dedicated Microsoft Support Engineer by contacting > Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/subscriptions/support/default.aspx. > > ================================================== > (This posting is provided "AS IS", with no warranties, and confers no > rights.) >
Have you looked at MSI packages?
You could probably package most of the elements. MSI packages can be used for SQL scripts, which covers element 1, and might cover element 4, 5 and 6 if you can do this through SQL. It can also install dlls, covering element 2. I've never tried using msi against a web service, but it should be possible, and with the right setup of your package, you should be able to either deploy your reports or at least trigger a rss-script (reporting services script, not the blog rss :) ) that will deploy your reports. A bit of information here http://www.sqlmag.com/Article/ArticleID/22428/sql_server_22428.html A more hands-on example and article here http://www.csharp-home.com/index/tiki-read_article.php?articleId=152 If you decide on msi, please tell the NG what you do and how successful it turns out. Kaisa M. Lindahl Lervik [quoted text, click to view] "Henrik Skak Pedersen" <skak@community.nospam> wrote in message news:eY0e8DE7GHA.4116@TK2MSFTNGP03.phx.gbl... > Hello Wei Lu, > > We have a solution that contains the following elements: > > 1) SQL Scripts, which create views, tables, ect. > 2) Custom Report Items (CRI) which is contained in a DLL > 3) Reports (RDL files) > 4) Reporting Services User Roles > 5) Datasources > 6) Setup of policies (permissions) on each report > > We have to package the solution and deploy it to multiple customers. > > Best regards > Henrik. > > > "Wei Lu [MSFT]" <weilu@online.microsoft.com> wrote in message > news:OnGVeBD7GHA.2336@TK2MSFTNGXA01.phx.gbl... >> Hello Henrik, >> >> I am not sure what does your solution include. >> >> Based on my research and experience, you need to deploy those data >> seperately. >> >> For example, you need to run all the database scripts on the production >> environment and then, you could use the VS 2005 IDE to deploy the report. >> >> I am not sure what did you mean CRI dll and roles. Would you please >> specify >> it more clearly? >> >> Sincerely, >> >> Wei Lu >> >> Microsoft Online Community Support >> >> ================================================== >> >> Get notification to my posts through email? Please refer to >> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif >> ications. >> >> Note: The MSDN Managed Newsgroup support offering is for non-urgent >> issues >> where an initial response from the community or a Microsoft Support >> Engineer within 1 business day is acceptable. Please note that each >> follow >> up response may take approximately 2 business days as the support >> professional working with you may need further investigation to reach the >> most efficient resolution. The offering is not appropriate for situations >> that require urgent, real-time or phone-based interactions or complex >> project analysis and dump analysis issues. Issues of this nature are best >> handled working with a dedicated Microsoft Support Engineer by contacting >> Microsoft Customer Support Services (CSS) at >> http://msdn.microsoft.com/subscriptions/support/default.aspx. >> >> ================================================== >> (This posting is provided "AS IS", with no warranties, and confers no >> rights.) >> > >
Hello Henrik,
I agreee with Kaisa. You could setup a MSI package to deploy the SQL Script and use the RSS script to deploy the Report. Here are also some article for your reference: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/ht ml/vbtskcreatinginstallerforyourapplication.asp http://www.codeproject.com/dotnet/Win_App_Setup_Project.asp?df=100&forumid=2 50630&exp=0&select=1419048 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/ rsp_prog_soapapi_script_3ik1.asp Sincerely, Wei Lu Microsoft Online Community Support ================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Hello Henrik,
I am not sure what does your solution include. Based on my research and experience, you need to deploy those data seperately. For example, you need to run all the database scripts on the production environment and then, you could use the VS 2005 IDE to deploy the report. I am not sure what did you mean CRI dll and roles. Would you please specify it more clearly? Sincerely, Wei Lu Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== (This posting is provided "AS IS", with no warranties, and confers no rights.)
Hi ,
How is everything going? Please feel free to let me know if you need any assistance. Sincerely, Wei Lu Microsoft Online Community Support ================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |