Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql 2000 DB migration to SQL 2008 Expand / Collapse
Author
Message
Posted Monday, January 21, 2013 10:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 6, 2014 12:32 AM
Points: 186, Visits: 172
I wanted to migrate one of our SQL 2000 database to new SQL 2008 server.
So to check migration compatibility I executed SQL 2008 upgrade adviser for SQL2000 database.

Upgrade adviser showed me very less issues. So I checked some SQL2000 db objects manually and I 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 about this upgrade adviser issue? is there any alternative tool available to check db compatibility?
Post #1409632
Posted Monday, January 21, 2013 10:42 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:09 AM
Points: 870, Visits: 2,385
Ignore, mis read at the end of the day.

_________________________________________________________________________
SSC Guide to Posting and Best Practices
Post #1409649
Posted Tuesday, January 22, 2013 9:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 6, 2014 12:32 AM
Points: 186, Visits: 172
anyone knows about this issue?
Post #1410133
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse