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 |
|
deesincere1
Starting Member
1 Post |
 Posted - 2008-09-30 : 12:48:15
|
| Does anyone know if the SQL Upgrade Advisor let's you know which stored procedures used in SQL Server 2000 will not work in SQL Server 2005? I was able to run the SQL Server Upgrade Advisor successfully on my SQL 2000 database but did not see anything stating that the stored procedures would not work due to System Table name changes. Any input on the subject would be helpfulThanks Dee |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-01 : 21:01:34
|
| SSUA uncovers most of the incompatible objects. Rest you can capture trace if you have dynamic sql and input .trc file along with database analysis in SQl Server Upgrade Advisor. There is a tool called SQL Server Upgrade Assistant on Scalability Experts website that gives you step-by-step process to upgrade sql server 2005/sqlerver2008. Go to www.scalabilityexperts.com |
 |
|
|
|
|
|
SQL Upgrade Advisor and SQL 2005