One of the databases that has 180 reports pointing at it - is moving server.
There database is keeping the same name but there is no DNS alias on the existing server
The odbc driver will need to be updated to SQL server native client 11 and the Application Intent set to read only and Multi subnet fail over set to true
My problem is I will have to go into all 180 reports individually and set Datasource Location to the new server once set up. Then probably need to reschedule the reports that scheduled to pick up the new odbc
Is there any quicker way of doing this?