Solved

Migrating SQL Server Reports

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 r2 - Sum totals 2 25
SQL Querying data from 3 tables, all with 1 common column 4 36
SQL Function NOT ROUND 9 10
sql server query 6 9
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
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.

773 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