Migrating from QA to Production -- sql server reporting services

sql server reporting services : Migrating from QA to Production

troark
9/20/2004 4:26:07 PM

I've got a test RS server set up in QA. I want to move everything from it
to Production. Is there an easy way for me to move everything from the QA
server to the Production server?

Thanks

Jeff Dillon
9/20/2004 6:35:03 PM

Is there a good way to move even web files from QA to Production?

While at Microsoft, we used an internal tool. I'm surprised they never
released it.

Jeff

[quoted text, click to view]

RK Balaji
9/20/2004 9:55:00 PM

Jeff,

This is a must in my company as people who create the reports don't have
access to production servers. I need to provide some way of deployment of
these reports into the production servers. If you can give some guidance on
what to include in the tool, that will help me write a tool internally.

For now, I am thinking of just moving the report definition (using the
sample in MSDN) from QA to production and then to go to the production
server and manually setup other properties and subscriptions.. If there is
any other better way, please let me know.

Thanks

RK

[quoted text, click to view]

Bruce Loehle-Conger
9/21/2004 12:37:11 PM

You can not manually do this, the reason is that the deployment process is
not copying the RDL files. Look on the server and you will see there are no
rdl files. This is because the information is being stored in the database.
I believe you would need to create a little app that deploys using the
webservices.

Bruce L-C

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn