Hello, Running SQL 2008 R2 Standard Microsoft SQL Server Management Studio 10.50.1600.1 Microsoft Analysis Services Client Tools 10.50.1600.1 Microsoft Data Access Components (MDAC) 6.1.7600.16385 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 8.0.7600.16385 Microsoft .NET Framework 2.0.50727.4961 Operating System 6.1.7600 We have been testing SSRS and now have a new production server that we want to copy all aspects of SSRS to. I realize you can perform a database copy but we will be testing a variety of new reports/subscriptions and it would be nice to only copy those versus the whole database every time. Through my research have run across two apps: Tried to use this application http://www.sqldbatips.com/showarticle.asp?ID=62 but it requires .NET 1.1 and once it was installed I couldnt get the app to work, even with the developer. Found a tool called ReportSync http://code.google.com/p/reportsync/ but that does not copy the subscriptions and other aspects. Is there a way to accomplish this easily within SSRS and/or a third party utility with SQL 2008 R2 Standard as we will be wanting to test then copy these to our production server? Thank you

You could try Reporting Services Migration Tool.

You could try Reporting Services Migration Tool.

My specific question is to be able to "copy" SRSS report and/or reports and other aspects like Subscriptions without moving the "whole" database or doing a "migration" to another server. "We have been testing SSRS and now have a new production server that we want to copy all aspects of SSRS to. I realize you can perform a database copy but we will be testing a variety of new reports/subscriptions and it would be nice to only copy those versus the whole database every time." There must be a way to do this without performing a complete migration and thought with how vast an audience we have here thought there would be more repsonses?