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 2005 Forums
 SQL Server Administration (2005)
 SQL 2008 Upgradation - upgrade advisor issues

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-02-22 : 05:34:01
Hi,
I am doing in-place upgrade from 2005 to 2008.Upgrade adviser shows 2 issues.

Please help me to fix these issues.

1.Invalid object name "sys.symmetric_keys"
2.Full-text search has changed in SQL Server 2008.

Thanks,
Gangadhara

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-23 : 02:12:30
For the first one - what service pack are you running on sql server 2005? are you on at ;east on service pack 3?

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

prett
Posting Yak Master

212 Posts

Posted - 2013-02-25 : 00:07:00
For this error message: Full-text search has changed in SQL Server 2008: Please refer to In-Place Upgrade and Side-by-Side Upgrade sections in SQL Server 2008 Upgrade Technical Reference Guide, which listed detailed actions to upgrade Full-Text Search to SQL Server 2008 (applies to SQL Server 2008 R2 as well).
Go to Top of Page

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-02-27 : 00:01:10
Yes for the first issue i am on SQL server 2005 with SP3 but still its showing in upgrade advisor report with "when to fix -before"


Thanks,
Gangadhara MS
SQL Developer and DBA
Go to Top of Page
   

- Advertisement -