We are doing a parallel migration from SQL Server 2005 to 2008 R2. We've moved the database, Integration Services and Analysis Services over to the 2008 R2 server. In BIDS, I've migrated the solution successfully into BIDS 2008 and created a new data source for the 2008 R2 server.
Is it possible to piont the Data Source View to the new server? Or, do I need to create a new Data Source View that is based on the new server?
Thanks for your help and guidance.