Wednesday, November 3, 2010

Supplemental on SQL Server 2008 R2

After lunch today I picked the brain of the guy running the SQL 2008 R2 booth about the migration. Good news is that the data files, objects, compatibility level, etc is 100% backwards compatible. And when opening or deploying SSRS report rdl files for the first time under the R2 tools, they will be automatically converted. He recommended giving SQL writer 3.0 a look and for us to take advantage of the new component based functionality. Which enables drag and drop functionality to allow pre-developed components aka galleries to be reused.
The one thing he cautioned me on is the continued use of linked servers. He stated that in the not so distant future there will be an announcement on the depreciation of linked servers.
Published with Blogger-droid v1.6.4

2 comments: