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 |
|
anbusql
Starting Member
4 Posts |
 Posted - 2008-02-06 : 04:17:29
|
| Hi, Currently we have SQL server 2000 database for past 3 to 4 years. Now planning to move SQL Server 2005. The SQL 2000 database will be restored to 2005 server. My questions are,1. The SQL 2000 queries, Stored proc and views will work with SQL server 2005 without any changes?2. Do the SQL server 2005 have backward compatability with SQL Server 2000 or we need to convert any specific SQL script after converting to 2005.3. Is there any issues after conversion?Please help me in this area.Thanks in Advance!Thanks,Anbu |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-06 : 10:32:50
|
| It depends on a number of issues: for example , if you have your SQL 2005 set at compatibility at 90 , then there are some requirements you need to look Microsoft have an SQL 2005 upgrade advisor you can download and execute.Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-06 : 23:51:13
|
| >> Do the SQL server 2005 have backward compatability with SQL Server 2000 You can set db to compatibility level 80 on sql2k5. |
|
|
|
|
|
|
Issues after converting SQL 2000 database to 2005