Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 DB migration from SQL 2000 to SQL 2008 R2
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 01/22/2013 :  02:06:20  Show Profile  Reply with Quote
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?

Posting Yak Master

160 Posts

Posted - 01/29/2013 :  04:29:52  Show Profile  Reply with Quote
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

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 01/29/2013 :  10:22:19  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Go to Top of Page

Aged Yak Warrior

596 Posts

Posted - 02/02/2013 :  10:20:30  Show Profile  Reply with Quote
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 type_desc FROM sys.objects O WHERE O.Object_ID = M.OBJECT_ID), 
  sys.sql_modules M
  (Definition LIKE '%*=%' OR Definition LIKE '%=*%')
  2, 1
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000