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

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

harishajabe
Starting Member

India
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?

srimami
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

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1911 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
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

denis_the_thief
Aged Yak Warrior

Canada
581 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 
  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
  Previous Topic Topic Next Topic  
 New 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.03 seconds. Powered By: Snitz Forums 2000