Hi,
Would you recommend the best and easy way to transfer (or copy) the subscriptions from one reporting service to another reporting service in different server?
+1
A:
How many subscriptions are there?
If theres a low number easiest thing would be to recreate them manually on the other server.
If we are talking a fair amount then there is a database reporting services to store the subscription data I believe called dbo.Subscriptions. I would recommend looking there first to see if you can see the subscriptions.
Otherwise if you would be looking to transfer the whole reporting server database (schedules included) then the following link might be of use:
markdigi
2010-08-17 15:20:27
Hi.. i checked the subscription table and it contains 45 rows.. I cannot move the entire reporting service to another server as it will overwrite the exisiting reports in the target server. Can I just get the subscription table and re-insert rows to the target server?
2010-08-17 22:46:14
Yep should be easy enough to do, but unsure if it would be locked from modification as it is a system database, check your under the correct permissions role first.Copy and paste would be a good simple solution otherwise and you will need to do an import/export of the data:Right Click the DB > Tasks > Import/Export and the wizard will guide you though, heres a good link: http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm
markdigi
2010-08-18 08:42:32
Hi did this.. done the full backup of report server db and restored it to destination db.. but when i clicked on My Subscription on report server nothing showed.. then I queried the database and it showed 45 rows in subscription table.. do you know why it is not showing up?
2010-08-31 06:17:31
sorry.. fixed it.. the users table in report server db still pointing to the windows account of old server (e.g. oldserver\windowsaccount --> changed to newserver\windowsaccount)
2010-08-31 06:30:18