September 21, 2008 at 7:07 am
What do i need to watch for when migrating from 2005 to 2008? I will of course ensure that I can roll back to 2005 if problems occur!
September 22, 2008 at 3:36 am
If you are using Full Text search, the internals of this have been rewritten for SQL Server 2008. If you moved from SQL Server 2000 to 2005 and made no optimisations to your FT code, it should work well in 2008. If you have optimised your FT code to get the most out of 2005, it may not work as fast in 2008.
If you were using Notification Services in SQL Server 2005, you will need to download and install the separate NS package for 2008, as NS is no longer included in the product.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply