8.0 compatibility question

All,
I am upgrading an instance of SQL 2000 to SQL 2005.
Two of my applications have databases in this instance. According to their
vendors, these two applications are not compatible with SQL 2005.
However, these databases, although running in SQL Server 2005, are using 8.0
compatibility mode. I learned that databases stay in their original
compatibility mode when upgraded to 2005.
So my question is - if these databases remain in 8.0 compatibility mode
after an upgrade, doesn't that mean they will still work as if they were
running on SQL 2000 once I upgrade to 2005? And doesn't that mean they WON'T
break, which would save me the torture of porting them to a separate named
2000 instance and maintaining that instance?
Please, if anyone has any insight on this, let me know."Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
news:51F67FB1-BF4D-46F0-B6FB-31DEF7EEDF86@.microsoft.com...
> All,
> I am upgrading an instance of SQL 2000 to SQL 2005.
> Two of my applications have databases in this instance. According to
> their
> vendors, these two applications are not compatible with SQL 2005.
> However, these databases, although running in SQL Server 2005, are using
> 8.0
> compatibility mode. I learned that databases stay in their original
> compatibility mode when upgraded to 2005.
> So my question is - if these databases remain in 8.0 compatibility mode
> after an upgrade, doesn't that mean they will still work as if they were
> running on SQL 2000 once I upgrade to 2005? And doesn't that mean they
> WON'T
> break, which would save me the torture of porting them to a separate named
> 2000 instance and maintaining that instance?
>
8.0 Compatibility Mode is designed to minimize upgrade problems with SQL
2000 applications, running them in an environment as similar to SQL 2000 as
possible. However you still need to work with your application vendor to
make sure that they support your configuration.
David|||Unfortunately no. When you upgrade to 2005 the database structure is
changed. The 8.0 compatibility mode just turns off some of the new
features - it doesn't leave the database in SQL 2000 format.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
news:51F67FB1-BF4D-46F0-B6FB-31DEF7EEDF86@.microsoft.com...
> All,
> I am upgrading an instance of SQL 2000 to SQL 2005.
> Two of my applications have databases in this instance. According to
> their
> vendors, these two applications are not compatible with SQL 2005.
> However, these databases, although running in SQL Server 2005, are using
> 8.0
> compatibility mode. I learned that databases stay in their original
> compatibility mode when upgraded to 2005.
> So my question is - if these databases remain in 8.0 compatibility mode
> after an upgrade, doesn't that mean they will still work as if they were
> running on SQL 2000 once I upgrade to 2005? And doesn't that mean they
> WON'T
> break, which would save me the torture of porting them to a separate named
> 2000 instance and maintaining that instance?
> Please, if anyone has any insight on this, let me know.