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?