SQL Server MigrationsName

TitleMicrosoft Corporation

Migrations To SQL ServerWhy customers are making the moveWhy customers are making the move

1. To get on to the fastest growing relational database

2. To lower TCO

3. Improve Performance

4. Improve Security

5. Increase Developer Productivity

6. Better Decision Making with integrated End-to-End BI

SQL Server Migration - Top 3 Concerns Breaking the Ice.. Breaking the Ice..

SQL Server Migrations from OracleFew of the Many customers who Migrated to SQL ServerFew of the Many customers who Migrated to SQL Server

9 TB system migrated from Oracle with SSMA9 TB system migrated from Oracle with SSMA100 concurrent users, to be rolled out to 12,000100 concurrent users, to be rolled out to 12,000Great TCO Savings over Oracle, integration with VS.NetGreat TCO Savings over Oracle, integration with VS.Net

Mainframe migration & consolidationMainframe migration & consolidationUsing SSMA to move Oracle database to SQL ServerUsing SSMA to move Oracle database to SQL ServerUses SQL Server & VS.Net as enterprise standardsUses SQL Server & VS.Net as enterprise standards

Real-time process control migrated from OracleReal-time process control migrated from Oracle““We were going for Better - Faster - Cheaper. We We were going for Better - Faster - Cheaper. We attained all 3.” – George White, IS Managerattained all 3.” – George White, IS Manager

Global manufacturer of programmable logic devicesGlobal manufacturer of programmable logic devices Migrating Unix/Oracle Siebel system to SQL ServerMigrating Unix/Oracle Siebel system to SQL Server

Apparel & foot-ware maker with multiple brandsApparel & foot-ware maker with multiple brandsMoved 1 TB SAP/R3 platform from Oracle to SQL ServerMoved 1 TB SAP/R3 platform from Oracle to SQL Server$63K reduction in annual license & improved uptime $63K reduction in annual license & improved uptime

Mission critical system for tracking QA on devicesMission critical system for tracking QA on devicesUsed SSMA to reduce costs of migration from OracleUsed SSMA to reduce costs of migration from OracleGained development productivity and lower costsGained development productivity and lower costs

Significant reduction in costs

Better performance Reliability Easier database

management Data compression

(SQL Server 2008)

Migrated SAP to Microsoft® SQL Server® Enterprise Edition (64-bit) database software

Windows Server® Enterprise Edition for 64-Bit Systems

Lockheed Martin Missiles and Fire Control wanted to update its SAP infrastructure from UNIX/Oracle

Needed lower total cost of ownership

Required better performance

Lockheed Martin gains Enterprise-class capabilities with SAP on Windows, SQL Server

“The cost savings . . . turned out to be real. Everyone, including our CFO, was pleased with the move from UNIX and Oracle to Windows and SQL Server.” Brent Eckhout, SAP Technical Systems Manager, Lockheed Martin, Missiles and Fire Control

Where Benefits Come FromWhat our customers are seeing & saying:What our customers are seeing & saying:

• Industry-leading performance and scalability for real-world database workloads

• Many tools and features to optimize performance of any size database

• Widely-available Microsoft expertise lowers staff costs

• More database and application power per hardware dollar

• Leverage expertise of huge partner ecosystem

• Affordable standardization with a set of integrated technologies and tools

Getting StartedLearning what you need to make an informed decisionLearning what you need to make an informed decision Identify and connect key business and technical

contacts

Establish approach to determine appropriate business priority areas and technical migration plans

Fully assess application and data-platform for detailed go-forward implementation (automated tools & templates)

Assessment reporting provided can include… Application Complexity Analysis

Database Migration Estimates

Detail Project Plans

More…

Initiate deployment services with Microsoft Consulting Services and/or deep partner ecosystem

Using SQL Server Migration Assistant (SSMA)

Migrate SchemaMigrate Schema& Business Logic & Business Logic

Test the Test the Converted DBConverted DB

Convert theConvert theApplicationApplication

Test, Integrate Test, Integrate & Deploy& Deploy

Migrate Data Migrate Data

SSMA Migration AnalyzerSSMA Migration Analyzer

SSMA Data MigratorSSMA Data Migrator

SSMA Migration TesterSSMA Migration Tester

• SSMA: Automates components of database migrations to SQL Server• SSMAs (Oracle, Sybase, Access & PowerBuilder Analyzer)

9Microsoft Confidential

1111

2222

3333

4444

SSMA Schema ConverterSSMA Schema ConverterAssess the Assess the

Migration ProjectMigration Project

SQL Server Migration Assistant (SSMA)

SSMA Migration Analyzer

• Running it is the easiest way to start a migration project• Does the same as the Schema Converter, but doesn’t

show the conversion results• Preferably to run on a backup/development/test

database in order not to interfere with operations• You can archive (zip) the reports directory, let us know

(send email to ssmahelp@microsoft.com), and we’ll try to help you with interpreting the results

11

SSMA Schema Converter

• Almost never converts 100% (although, sometimes does - Motorola, Valero)

• Default settings usually work for the initial conversion, but may require changes (e.g. type mappings) as the project progresses

• Sometimes it’s easier to make changes in the source stored procedures rather than complete the conversion manually

• If you don’t know what to do with the conversion errors:‐ save the converted code as a script or save a project

file‐ send it to ssmahelp@microsoft.com‐ SSMA support team will analyze the script and will

provide some help

12

SSMA Data Migrator

• SSMA for Oracle v2 – uses linked server to move data‐ logged operation => slower than SSIS‐ good enough when need to move low data volumes

• SSMA for Sybase/Access/Oracle v3-4 – uses direct pipe to move data‐ reads and writes data using non-logged operation‐ on par with SSIS or bcp out/in‐ doesn’t write to the disk

13

SSMA Migration Tester

• Was introduced first in SSMA for Oracle v3.1 (August ‘07)

• Exists in SSMA for Oracle and Sybase v4• Typically used for unit testing of converted stored

procedures• Customers prefer to run it on existing data sets, rather

than letting the tool to create data• The next most expensive migration step after the

schema conversion

14

SSMA Migration Challenges

• Oracle FormsOracle Forms• Row-level triggersRow-level triggers• PackagesPackages• Package variablesPackage variables• Collections (nested Collections (nested

tables, VARRAYs, tables, VARRAYs, objects)objects)

• System packages System packages (not supported by (not supported by SSMA Extension SSMA Extension Pack)Pack)

• Outer joinsOuter joins• RAISERRORRAISERROR• PRINTPRINT• UPDATE with aliasUPDATE with alias• Comparison and Comparison and

concatenation with concatenation with NULLNULL

• Sybase-to-SQL Sybase-to-SQL replicationreplication

• Conversion queriesConversion queries• Application Application

performance post performance post migrationmigration

“Without SSMA, it would have been a huge undertaking just to inventory and catalog the system,

let alone do the conversion.” Tom Masciovecchio,

Director of Publishing Systems, Simon & Schuster

“SQL Server Migration Assistant allowed us to migrate the database in just one day with 100% accuracy. Our DBA

was able to stay focused on more important things.”Gordan Redzic,

Automation Team Lead, iDEN Automation Group, Motorola

SQL Server Migration Assistant (SSMA) was very simple to use and ensured

data integrity and accuracy during the migration.”Sanjay Bhadra,

Alliance Manager, Sonata Software

“SSMA automated the migration, saving us from having to do hours and hours of manual coding.”

Paulo Henrique da Silva, IT Manager, Atento

All case studies and testimonials are at: http://www.microsoft.com/sql/migration/custevidence.mspx

SQL Server Migration Assistant Customer Evidence

16

Call to Action & Resources

17

• Consider migration opportunities to SQL Server in your existing ecosystem Consider migration opportunities to SQL Server in your existing ecosystem • Leverage the available tools & resources – Download SSMA now!Leverage the available tools & resources – Download SSMA now!

Resources

Call to Action

Resources Links

SQL Server Migration Solution Center

http://www.microsoft.com/sqlserver/2008/en/us/migration.aspx

SQL Server Migration Assistants http://www.microsoft.com/Sqlserver/2005/en/us/migration.aspx

SQL Server Migration Assistant Support

SSMAhelp@microsoft.com

Follow / Join us online: Twitter @sqlpass #sqlpass, LinkedIn group, Facebook group

© 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market

conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

Appendix

Market Data Dissemination System5K txs / second, 100K queries / day, running on SQL Server

• Fixed Income Trade and Positioning Systemrunning on SQL Server

• 30% performance increase, capacity to process 1,000 trades / second

• 22TB of data on SQL Server• 99.999% uptime, scalability for

30% annual growth

• Web solution managing millions of devices,7 million txs / day, with 99.999% uptime running on SQL Server

Enterprise class Enterprise class performance and large performance and large database handlingdatabase handlingIntegration with the Integration with the VS.Net development VS.Net development platformplatformTCO savings and TCO savings and Lower cost of Lower cost of managementmanagement

8.1 TB OLTP/DW 8.1 TB OLTP/DW Hybrid SystemHybrid SystemStoring 3 years of Storing 3 years of transaction data; will transaction data; will grow to 5 yearsgrow to 5 yearsData mining enables Data mining enables better out-of-stock better out-of-stock predictionspredictions

Health Insurance Health Insurance Services CompanyServices CompanyKeen on saving Keen on saving costscostsNeeded improved Needed improved high-volume data high-volume data loading and analytic loading and analytic query performancequery performance

"Adding things like a reporting solution or OLAP services, the costs just kept building up on the Oracle side while they remained the same on the SQL Server side."—Adam Soles by, Director of Strategic Development, AIM Healthcare Services

8+ Terabytes Database on one SQL Server

Lower TCOMake Your capex and opex dollars go fartherMake Your capex and opex dollars go farther

“The savings from moving from Oracle to SQL Server were so significant—exceeding $500,000 a year and providing an ROI of less than 12 months—that at first the numbers weren’t believed.”

Ken Kemker, Director of Enterprise ArchitectureKen Kemker, Director of Enterprise ArchitectureKimball International

Enrollment for Application Platform decreases licensing and maintenance costs

Widely-available Microsoft expertise lowers staff costs

More database and application power per hardware dollar

Avoid expensive, forced upgrade to Oracle 11g

Higher PerformanceGetting more from your database investmentsGetting more from your database investments

Industry-leading performance and scalability for real-world database workloads

Many tools and features to optimize performance of any size database

SQL Server 2008 Database Compression for superior storage utilization

“With the new Microsoft Application Platform and HP infrastructure our SAP system performance is 3 times faster than our previous Sun/Solaris/Oracle solution.

Ahmet Ihsan Ceylan, Chief Information OfficerAhmet Ihsan Ceylan, Chief Information OfficerArçelik

SQL Server Migration Assistant (SSMA) for Oracle

Assess theMigration Project

Migrate Schemaand Business Logic

Migrate Data

Test the Converted DB

SSMA Migration Analyzer

SSMA Schema Converter

SSMA Data Migrator

SSMA Tester

Migration Steps and SSMA ModulesMigration Steps and SSMA Modules

SSMA Migration AnalyzerSSMA Migration Analyzer Running it is the easiest way to start a migration project Fill out the questionnaire – helps with understanding the

environment Does the same as the Schema Converter, but doesn’t

show the conversion results Preferably to run on a backup/development/test

database in order not to interfere with operations

SSMA Schema ConverterSSMA Schema Converter Almost never converts 100% (although, sometimes does -

Motorola, Valero) Default settings usually work for the initial conversion, but may

require changes (e.g. type mappings) as the project progresses

Sometimes it’s easier to make changes in the source stored procedures rather than complete the conversion manually

CoE provides direct support on conversion errors:

SSMA Data MigratorSSMA Data Migrator SSMA for Oracle – uses linked server to move data

logged operation => slower than SSISgood enough when need to move low data volumes

SSMA for Sybase/Access/Oracle – uses direct pipe to move datareads and writes data using non-logged operationon par with SSIS or bcp out/indoesn’t write to the diskAllows to modify the SELECT statement

SSMA Migration TesterSSMA Migration Tester Typically used for unit testing of converted stored procedures Customers prefer to run it on existing data sets, rather than letting the

tool to create data The next most expensive migration step after the schema conversion

Sample Project TimeframeCustomizing your migration projectCustomizing your migration project

Note: This is an exhaustive list of potential services with time estimates. Actual projects may vary in scope and timing

• SQL Server Total Cost of Ownership‐ No price increase for SQL Server 2008‐ Migration calculations http://www.cioview.com/ ‐ Learn of the total economic impact deploying SQL Server 2008 can have:

New Independent Study Finds 162% Risk-Adjusted ROI for SQL Server 2008

• Enterprise Data Platform: Microsoft SQL Server 2008 provides a data platform with many advantages and business benefits: better security, performance and scalability, developer productivity, and Business Intelligence tools (BI)

‐ SQL Server Enterprise Data Platform

• SQL Server Features & Function: In depth comparison analysis with key competitors demonstrate the power of SQL Server.

‐ Oracle Comparisons‐ SQL Server 2008 compared to Oracle 11g database. Deployment‐ Why use SQL Server instead of Oracle for SAP

‐ Compare SQL Server to IBM DB2‐ Compare SQL Server to MySQL‐ Redmond Magazine: SQL Server Closing the Gap

• SQL Server Security & Compliance: SQL Server 2008 is secure by design, default, and deployment. The following resources define these capabilities.

‐ SQL Server 2008 Security Overview for Database Administrators‐ Compliance Guide for SQL Server 2008

The Value of Migrating to SQL ServerWhy should customers consider migrating to SQL Server?

27

Typical Migration Scenarios

• Two types of applications:‐ Custom-written: Migration can be done with the

customer and a partner‐ Packaged: Talk to the ISV

• Always do assessment first! • (using Migration Analyzer module of SSMA +

questionnaire)• Many times involves working with SI specializing

in database migrations

28