Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Migrating SQL Server Reports

Posted on 2013-11-03
2
Medium Priority
?
246 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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

886 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