Migrating SQL Server Reports

We use an SQL Server 2008 R2 instance for Axapta. We have just acquired another businesses SQL Server which is also 2008 R2, which they use for QAD ERP and MORE applications. We already have these applications running new reports on our SQL Server. We need to migrate the old reports data and/or reporting service to our SQL Server without overwriting or disturbing any of our data.

What is the best approach for this?
CiaranDeAsked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
"We need to migrate the old reports data and/or reporting service to our SQL Server without overwriting or disturbing any of our data."

What do you mean by "old reports data"? existing snaphots history, etc? or the actual SQL databases where the "old reports" are getting their data ?

Also "We need to migrate the old reports data and/or reporting service ..." - why when you say that "We have just acquired another businesses SQL Server which is also 2008 R2, which they use for QAD ERP and MORE applications. We already have these applications running new reports on our SQL Server. "

In my opinion all you would need is to migrate your RDL's and set them on the new server - eventually you may need to bring in the reports data (SQL Databases where they connect to) into the new server if you want to get rid of the old SQL Server.

Here's one example to do that:

http://blogs.msdn.com/b/tfssetup/archive/2012/12/19/moving-rdl-files-from-one-reporting-services-instance-to-another.aspx
0
 
CiaranDeAuthor Commented:
Just to clarify, the old databases have been moved to our sql server with SSRS setup and already running. So new reports are being generated on the old and current data.

We need to move the old reports which were on the old sql server and import them into our current sql server. These reports were of the old database. We need to be able to view these old reports on our sql server.

I meant we already have new reports running, we just need to merge the old reports in with our sql server, so we can view old reports. We only have reports from the time of migration moving forward, not prior migration.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.