I have an old database running on compatibility level 6.5 on a SQL Server 2005 instance.
The support for compatibility level 6.5 has been deprecated as of 2005 and removed on 2008.
The place where I work is split in various different companies, each responsible for different things like Databases, Infrastructure and Development. Needless to say I work at the database.
This matters because we have an old 7.0 instance running, and we'd like to be able to move this 6.5 database to that instance and upgrade the 2005 instance to 2008 R2, but for that we can't request changes at the software level, it would have to be seamless, and this database is referenced by pretty much every other database on the instance.
We have thought about tracing for references of this database and changing the affected T-SQL code in order to use a linked-server.
Would that be a good idea, or are there simpler and more straightforward alternative ways of doing this?