O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required