Upgrade Options in SQL Server 2012
When you restore a SQL 2005 full-text enabled database to a SQL 2012 server, the full-text catalog will be imported into a separate filegroup in the database in its own filegroup. This is a change from SQL 2005, where the full-text catalogs were stored in the file system. A catalog rebuild should be done to take advantage of the new SQL 2012 word breakers. A SQL 2008 and SQL 2008 R2 full-text enabled database backup will be restored into the primary filegroup.
When you attach a SQL 2005 full-text-enabled database to a SQL 2008, SQL 2008 R2, or SQL 2012 server, you are prompted to attach the SQL 2005 full-text catalog when you use the wizard, and the attach database process will fail.
If you use T-SQL commands ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
