Sql 7 vs Sql 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sql 7 vs Sql 2000

Hi, Anybody can tell me where to check the different between sql 7 and sql 2000? currently my customer are using sql 7 for their racking system. and our system which is using sql 2000, need to retrieve data from their racking system to do some processing and update. I am not sure what is the thing i need to consider, as i didnt use sql 7 before and we have no sql 7 for us to do testing. FYI, currently we r using Delphi and MDAC version 2.7. is there any problem to use MDAC 2.7 to connect to sql 7?
Check SQL server books online for SQL 2000 in order to see version difference & compatibility between SQL 7 and 2K. Basically there is no major difference in 7 & 2000 as compared to 6.5 and 2000 and in performance aspects SQL 2K is far better than version 7. 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.
quote:Originally posted by satya Check SQL server books online for SQL 2000 in order to see version difference & compatibility between SQL 7 and 2K. Basically there is no major difference in 7 & 2000 as compared to 6.5 and 2000 and in performance aspects SQL 2K is far better than version 7. 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.
Hi, is there any problem when connect sql 7 with latest mdac version?
No, I did it and there is no problem.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
In general its recommended to have similar versions of MDAC with service pack levels, in order to get optimum results and avoid any version difference issues. 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.
]]>