September 15, 2010 at 11:13 am
We are decommissioning one of our servers that runs SQL Server 2000.
I am trying to move the database that currently resides on this SQL Server 2000 box to another server that is running SQL Server 2005.
What I've done is detached the database from 2000 instance, copied the MDF and LDF files to the 2005 server, attached the database in SQL Server 2005 and set the compatibility level to SQL Server 2005(90).
The problem I'm running into is that this database, when viewed on the SQL 2000 box, has 53 tables. When I open it up on the SQL 2005 box, it has 34 tables. I'm not sure what's happening here, but it seems that when I attach the 2000 dB to the 2005 instance, the structure is automatically changed.
Is the detach/attach the best option for doing this, or is there a more appropriate way of going about this?
September 15, 2010 at 11:20 am
no way detach/attach affects number of tables.
SQL2005 splits tables up into separate headings - system tables and non system, is that it?
---------------------------------------------------------------------
September 15, 2010 at 11:27 am
Yeah that's pretty much the issue I'm running into - the system tables that appear under 'Tables' in SQL 2000 appear under 'System Views' in SQL Server 2005.
September 15, 2010 at 11:35 am
There's nothing you can do about that. The system tables are changed in 2005 and above, and they'll move with the new tools.
Code shouldn't reference them, but if it does, it will still work.
September 15, 2010 at 11:36 am
Welcome to SQL 2005 🙂
September 16, 2010 at 5:10 am
Hello Everyone
I need to update SQL SERVER 2000 to SQL SERVER 2005 and SQL SERVER 2005 to SQL SERVER 2008 so please tell me the steps to be followed for doing so.
Thanks in Advance
V.Santosh.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply