sql server 2008 migration

– Brief Overview of SQL Server 2008– Brief Overview of SQL Server 2008

– SQL Server Feature Pack– SQL Server Feature Pack

– SQL Server Migration Assistant– SQL Server Migration Assistant

– Case Study– Case Study

– SQL Server 2005 vs. 2008– SQL Server 2005 vs. 2008

– Microsoft Gold Certified Partner– Microsoft Gold Certified Partner

– Based in Emeryville– Based in Emeryville

– Custom Software, Databases, and BI Solutions on– Custom Software, Databases, and BI Solutions onthe Microsoft Platformthe Microsoft Platform

– .NET, SQL Server, SharePoint– .NET, SQL Server, SharePoint

– Based in the U.S. and France– Based in the U.S. and France

– Database Consulting– Database Consulting

– Technical Publications / Books– Technical Publications / Books

BENEFITBENEFIT

• Spatial Support

BENEFITBENEFIT

• Spatial Support• Filestream Support• Filestream Support• Hierarchy Id Support

Significant Application, Operational orSignificant Application, Operational or• CDC* & Change Tracking• LINQ Support

Significant Application, Operational orDeployment Changes

Significant Application, Operational orDeployment Changes

• LINQ Support• Entity Framework Support

Deployment ChangesDeployment Changes

• Entity Framework Support• ADO.NET Data Services Support

• Policy Based Management (DMF)• Policy Based Management (DMF)• Performance Data Collection

Moderate Application,Moderate Application,• Performance Data Collection• Enhanced date and time support• Transact-SQL enhancements

Moderate Application,Operational, or

Moderate Application,Operational, or• Transact-SQL enhancements

• Sparse column supportOperational, or

Deployment ChangesOperational, or

Deployment Changes• Sparse column support• Service Broker enhancements

Deployment ChangesDeployment Changes• Service Broker enhancements• SSIS / SSRS / SSAS enhancements*

• Data/Backup Compression*MinorMinor

• Data/Backup Compression*• Transparent Data Encryption*• Resource Governor*

MinorChanges

MinorChanges• Resource Governor*

• Filtered Indexes/StatisticsChangesChanges

• Filtered Indexes/Statistics• Query Optimizer / Storage Engine enhancements*• Query Optimizer / Storage Engine enhancements*• Enhanced SQL Server Audit*• SSRS/SSAS scalability improvements*• SSRS/SSAS scalability improvements*

* Requires Enterprise Edition* Requires Enterprise Edition

Enterprise Data Platform

• Secure, trusted platform for your data• Secure, trusted platform for your data

• Optimized and predictable system performance• Optimized and predictable system performance

• Productive policy-based management of your infrastructure• Productive policy-based management of your infrastructure

Beyond RelationalBeyond Relational

• Store and consume any type of data• Store and consume any type of data

• Deliver Location Intelligence within your applications• Deliver Location Intelligence within your applications

Dynamic DevelopmentDynamic Development

• Accelerate your development with entities

• Synchronize your data from anywhere• Synchronize your data from anywhere

Pervasive InsightPervasive Insight

• Integrate all your data in the Enterprise Data Warehouse• Integrate all your data in the Enterprise Data Warehouse

• Reach all your users with scalable BI platform• Reach all your users with scalable BI platform

• Empower every user with actionable insights• Empower every user with actionable insights

– Pro-active, flexible– Pro-active, flexibleadministrationadministration

– Configuration Servers– Configuration Servers

– Used beyond performance– Used beyond performancemonitoring/tuning; e.g.monitoring/tuning; e.g.workload profiling, capacityworkload profiling, capacityplanningplanning

– Predictable query behavior– Predictable query behavior

– Greater opportunities with tools like Resource Governor and– Greater opportunities with tools like Resource Governor andExtended Key ManagementExtended Key Management

– Providing flexible security in shared instances and shared servers– Providing flexible security in shared instances and shared servers

– Leverages Windows Server 2008 feature– Leverages Windows Server 2008 feature

– Easier to support since technologies are from single vendor– Easier to support since technologies are from single vendor

– Not just about dev/test and training– Not just about dev/test and training

– SQL Server Data Services– SQL Server Data Services

– Data Mining for Excel– Data Mining for Excel

– Native PHP Scripts– Native PHP Scripts

– BLOB Store– BLOB Store

– System CLR Types for External Applications– System CLR Types for External Applications

– Sync Framework– Sync Framework

– Upgrade Advisor!– Upgrade Advisor!

– And more…– And more…

→→

→→

→→

→→

Migration AnalyzerMigration Analyzer

Assess theAssess theMigration Project Schema MigratorMigration Project Schema Migrator

Migrate SchemaMigrate Schemaand Business Logic Data Migratorand Business Logic Data Migrator

Migrate Data Migration TesterMigrate Data Migration Tester

Test theConverted DatabaseConverted Database

Runtime Converter (RTC) (to Convert theRuntime Converter (RTC) (tobe developed)

Convert theApplicationbe developed)

Test, Integrate,and Deployand Deploy

Application and Compatibility Content & ToolsApplication and Compatibility Content & Tools

– Application Compatibility Blog– Application Compatibility Bloghttp://blog.scalabilityexperts.comhttp://blog.scalabilityexperts.com

– SQL Server 2008 Upgrade Advisor– SQL Server 2008 Upgrade Advisorhttp://www.microsoft.com/sqlhttp://www.microsoft.com/sql

– Upgrade Assistant– Upgrade Assistant

• http://www.scalabilityexperts.com/default.asp?action=article&ID=43• http://www.scalabilityexperts.com/default.asp?action=article&ID=43

– Reporting Services Scripter– Reporting Services Scripter

• www.sqldbatips.com/showarticle.asp?id=62SQL Server 2008• www.sqldbatips.com/showarticle.asp?id=62SQL Server 2008http://www.microsoft.com/sql/2008/default.mspxhttp://www.microsoft.com/sql/2008/default.mspx

– SQL Server 2008 Feature Pack – April 2009– SQL Server 2008 Feature Pack – April 2009

• http://www.microsoft.com/downloads/details.aspx?FamilyID=b33d2c78-1059-4ce2-b80d-• http://www.microsoft.com/downloads/details.aspx?FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4&displaylang=en

Microsoft SQL Server Community & SamplesMicrosoft SQL Server Community & Sampleshttp://www.codeplex.com/SqlServerSamples