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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-20 : 07:50:02
|
| Vishal writes "I am planning to migrate my application database from 2000 to 2005. What are the changes required to my SQL queries to work fine on 2005?" |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2006-12-20 : 08:53:17
|
| Hello Vishal,I have one answer to your query and that is, Microsoft SQL Server 2005 Upgrade Advisor. This is a tool from microsoft. You can run this tool against your database. This will tell you the problem which you can face while upgrading/After upgrading.You can also supply SQL trace file to this tool. This will help to check the compatibility of any adhoc query getting executed in your database.You can download this tool from the below link.http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=enThanksSachin Don't sit back because of failure. It will come back to check if you still available. -- Binu |
 |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
|
|
|
|
|
SQL server 2000 to 2005 migration