?
Solved

Migrating SQL Server Reports

Posted on 2013-11-03
2
Medium Priority
?
248 Views
Last Modified: 2013-11-07
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?
0
Comment
Question by:CiaranDe
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 39621913
"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
 

Author Comment

by:CiaranDe
ID: 39629629
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question