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 |
|
harishajabe
Starting Member
1 Post |
 Posted - 2013-01-22 : 02:06:20
|
| Hi All,we are migrating one of our SQL 2000 database to new SQL 2008 R2 server. So to check migration issues, I executed SQL 2008 upgrade adviser for SQL2000 database. Upgrade adviser showed me very less issues. So I manuallu checked some SQL2000 db objects and found it is not reporting all issues. Like one of the SP is using non-ansi join (=*) but it is not reported by upgrade adviser.anyone knows why this is not coming in upgrade adviser report? is there any alternative tool available like upgrade adviser? |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-01-29 : 04:29:52
|
| I am not sure on this Upgrade adviser but there shouldn't be any issues migrating from 2000 to 2008 R2 |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-29 : 10:22:19
|
| At what compatibility level do you have the db set at.?I have in the past seen the message come up on the SQL Server 2008 R2 Upgrade Advisor for *=, but it doesn't seem to report it for the 2012 upgrade advisorYou could also consider rewriting the queries with LEFT OUTER JOINJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2013-02-02 : 10:20:30
|
We were in the same position. Not sure why Upgrade Advisor did not tell you about *=. In any event, you can either convert these or run 2008 in compatibility mode 2000 (i.e. 8). If you can, convert these!In any event, here is a query to identify these:SELECT OBJECT_NAME(object_id), (SELECT type_desc FROM sys.objects O WHERE O.Object_ID = M.OBJECT_ID), *FROM sys.sql_modules MWHERE (Definition LIKE '%*=%' OR Definition LIKE '%=*%')ORDER BY 2, 1 |
|
|
|
|
|
|
DB migration from SQL 2000 to SQL 2008 R2