Solved

Migrating SQL Server Reports

Posted on 2013-11-03
2
236 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 39

Accepted Solution

by:
lcohan earned 500 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now