Based on the books online I am not allowed to upgrade a database at sql server 2000 to sql server 2008. But I tried restoring the sql server 2000 backup on the Katmai release available and it works. It initially did have the database in sql server 2000 compatibility mode but later I was even able to change the mode to be 2008 compatible.
So what is it am I allowed to do it or not?
I think it means that you cannot upgrade a SQL Server 2000 instance to SQL Server 2008.
The database itself should be compatible (one way of course). What exactly is stated in the BOL?
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
|||You can upgrade a SQL Server 2000 database directly to SQL Server 2008.
This is fully supported.
Not all of the upgrade setup code is in yet, so there are limitations on what upgrade scenarios are supported at this point. (Actually, I don't believe any instance upgrade is supported as of the July CTP.)
If you can give me a pointer to the BOL section you read, I'll make sure it is correct, or get it corrected.
Thanks
No comments:
Post a Comment