I will migrate an SQL server from 2000 to 2008 R2. It contains two instances. I have many stored procedures that are referencing the instance names like:
select ... from [old_server\instance1].db1.dbo.table1
What is the best way to deal with these stored procedures?
- Modify all stored procedures and change these occurrences
- Do not change the stored procedures, but create a reference from the old server to the new one using
- Rename the new server after the migration to keep the old name