Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
WindChaser
Posting Yak Master
225 Posts |
 Posted - 2008-02-28 : 09:56:28
|
| Hi there!Our application currently uses SQL Server 2000 as a DB manager and we have over 200 clients which have different versions, either Standard or MSDE. We now wish to start using SQL Server 2005 or 2008 without necessarily forcing existing clients to upgrade. Of course, this would only be possible if SQL Server 2005 is compatible with the code in our application which is "Transact-SQL 2000" (if I can call it that way). Are there any difference between Transact-SQL statements in 2000, 2005 and 2008? If so, where could I find a comparative reference?Thanks!Mike |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-02-28 : 21:52:48
|
There are some differences, but you can install the SQL 2000 DB on 2005 with compatibility mode of 80 (instead of 2005's which is 90) to overcome some things. There are major differences in system tables and such.T-SQL is the same, but since table structures, system tables and such may be different, there will be some functionality differences (as with lots of things "it depends on your database and the t-sql involved".start here: http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
SQL-Transact compatibility between 2K and 2008