Migrating subscriptions from 2005 - 2008

Question

Migrating subscriptions from 2005 - 2008

Lord Slaagh

SSCertifiable

Points: 5741
More actions
June 17, 2014 at 7:22 am

#290182

Hello,
I am in the process of migrating over 300+ reports from SQL 2005 - 2008. I have a few tools that can help me with this, however I have a ton of subscriptions to move as well. Has anyone dealt with moving subscriptions from 2005 - 2008?
Any help would be appreciated.
SQL-TG
The are no problems, only solutions. --John Lennon

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

small world, i just had to do this as well.

my hiccup was my original target server was 2008 standard, and not Enterprise, so i migrated reporting services, but the subscriptions didn't work because of the version;

I had to redeploy to 2008 Enterprise.

the process was actually pretty easy:

backup the encryption key for reporting services on the 2005 server.

backup three databases:

ReortServer.

ReportserverTempDB.

Subscribers.

Make sure the 2008 server was all set up with SQL enterprise and reporting services .

restore the three databases on SQL server.

open Reporting Services, and restore the encryption key , and point the connection to the database i restored to.

as soon as i did that, a suite of jobs form reporting services got created (they all start with a GUID), and when i went to http://ThatSpecificServer/Reports,

i could drill down into the subscriptions, and they were all there.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Lord Slaagh SSCertifiable Points: 5741 More actions · Answer 2

Thanks very much Lowell!

The are no problems, only solutions. --John Lennon

Lowell SSC Guru Points: 323518 More actions · Answer 3

another thing i noticed, that was minor, but affected me nonetheless:

2008 has better exports to excel: it is able to name worksheets, and a report that had data that started on say, cell A8 with rows 1-7 containing various header information, now might start on a different row, or be variable on a per-report basis.

i had some folks that hard macros that were hardcoded to expect data in a specific cell,a dn the cells changed with the differene between 2005 and 2008's exporting of excel.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Lord Slaagh SSCertifiable Points: 5741 More actions · Answer 4

Thanks for the tip. Not sure if these guys use excel, but that is good to know. You may have saved me research time if this issue arises. Cool!

The are no problems, only solutions. --John Lennon