SQL Server Performance Forum – Threads Archive

Porting to version 2000

Hi Group,
I’ve installed SQL 2000 on my machine, however the existing SQL is version 7.0. I can connect to the version 7 database. My questions are: 1. Are files structures the same in version 2000 as it is in version 7? 2. Will I do any damage if I queried data held in version 7.0 using version 2000? Kind Regards

As for 1.
Sorry, haven’t worked long and therefore intensively enough to said something about SQL 7 filestructures. But since you can simply detach on SQL 7 and reattach on SQL 2000 I guess there is no significant change. As for 2.
No, never experienced any trouble adminstrating SQL 7 and querying data from the SQL 2000 client tools. –Frank
http://www.insidesql.de

Yes you can handle/manage/administer SQL 7 database server using SQL 2000 tools without any issues. 1. File structers are same and I suggest you to refer to Books online for Version Compatibility topic for ‘SQL Server 2000 and SQL Server version 7.0’ for further information. 2. No need to worry, no damaage is caused. Further, we have 20 services running under version 7 and managed by SQL 2000 tools without any sort of hiccups.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks FrankKallis, Satya!!

Just make sure you are running under comaptibility 70 until you are sure that you are not using any features that are no longer supported in SQL Server 2000. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

Be careful keeping compatability mode 70. I would rather just test it to death in a dev and QA environment and move. That’s what I’ve done on all my conversions, and I was involved in some large ones. I’ve seen people go to 70 compatability mode and they are still using it today. Now, there’s just that much more code and issues to deal with. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

For simple querying the data, I don’t think compatibility mode 70 is necessary. I can’t remember using it.
–Frank
http://www.insidesql.de

I agree with Frank, we never set that configuration and by default SQL 2K tools recognises the ver.7 database as CM 70. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>