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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 DB migration from SQL 2000 to SQL 2008 R2

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
Go to Top of Page

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 advisor

You could also consider rewriting the queries with LEFT OUTER JOIN

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

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 M
WHERE
(Definition LIKE '%*=%' OR Definition LIKE '%=*%')
ORDER BY
2, 1
Go to Top of Page
   

- Advertisement -