Oracle To SQL Server Migration:
Business Value Proposition
Michele Zoppi
Product Manager SQL Server & BPI
[email protected]
Agenda della giornata
9.30 – 9.45
9.45 – 11.15
11.15
Introduzione, novità, pacchetizzazioni e prezzi di Microsoft
SQL Server 2005
Perchè migrare? Oracle e SQL Server 2005 messi a
confronto
Coffe Break
11:30 – 13.00
Sql Server Migration Assistant Techinical overview:
Analisi di Migration Analyzer, Schema Migration, Data
Migrator e Migrator Tester
Best Practice di migrazione
I primi passi per affrontre con successo un processo di
migrazione
13.00 – 14.00
Lunch
14.00 – 15.30
SSMA visto da vicino
Esempi reali e tecniche di migrazione da ASP/COM, JSP,
.NET con Oracle con una overview su JLCA (Lava Language
Conversion Assistano)
15.30 – 15.45
Intervallo
15.45 – 17.15
Un esempio reale
Attività di porting da java/ Oracle verso ASP.NET e SQL
Server
17.15 – 18.00
Domande e Risposte
Agenda
Perchè Migrare
SQL Server 2005: Pacchettizzazioni e
prezzi
Offerte commerciali
What Are Some Customers Saying?
“Wanted to consolidate databases from
10 publishing systems”
“Needed alternative to high cost of
Oracle databases”
“To take advantage of the new .NET
technologies for improved developer
productivity”
“Oracle database was time-consuming,
complex and difficult to maintain”
Oracle To SQL Server
Why should customers migrate?
1.
2.
3.
4.
5.
6.
To get on to the fastest
growing relational
database
To lower TCO
Improve Performance
Improve Security
Increase Developer
Productivity
Better Decision Making
with integrated End-toEnd BI
2004 Relational DB Market
Non-mainframe
DB ($6 Bil)
Non-mainframe DB
($5.4B)
Growth & Shares By OS Platform
2004
Other
11%
IBM
20%
+2
+2%
SQL
Server
26%
Unix/Linux
49%
Windows
51%
+18
+18%
Oracle
43%
2003
Other
12%
IBM
22%
SQL Server
Leads on Windows
SQL
Server
24%
Windows Database
Market ($3.1 Bil)
Passed
IBM in
2003
+15%
+15
Windows is
the leading
Oracle
42% OS platform
Other
8%
IBM
16%
SQL
Server
51%
Oracle
25%
Source: Gartner
Oracle 10g
Base Product
$ 25K
$ 40K
IBM DB2
$ 25K
Tuning
$3K
Diagnostics
$3K
Partitioning
$10K
Performance
Expert
$10K
$ 56K
40K
$ 35K
25K
(included)
Manageability
Base Product
$ 25K
OLAP
$20k
Mining
$20k
BI Bundle
$20k
DB2 OLAP
$35K
DB2
Warehouse
$75K
Cube Views
$9.5K
Business
Intelligence
(included)
Manageability
Base Product
$ 25K
$$ 116K
56K
$ $154.5K
35K
Data Guard
$116K
Recovery
Expert
$10k
High Availability
Business
Intelligence
(included)
Manageability
Base Product
$ 25K
$ 232K
116K
$ 164.5K
154.5K
$116K $232K
$164.5K
$$348k
232K
$464k
$$164.5K
329K
Multi-core
Business
Intelligence
High Availability
(included)
Manageability
Base Product
$ 25K
But I Already Paid For Oracle…
Yes, still worth migrating!
“Should you Migrate from Oracle to SQL
Server?” – Business White Paper
http://www.microsoft.com/sql/migration/oraclemi
gratewp.mspx
ROI/TCO Calculation Tool:
http://www.cioview.com/Snapshot/Snapshot/Cu
stomer_OracleMigrationSQL.aspx?Snapshot=O
racleMigrationSQL
Savings in Oracle Maintenance fees will offset any new costs!
SQL Server 2005
Better performance than Oracle on equivalent hardware
TPC-C results referenced above are HP Integrity Superdome running SQL Server 2005, 1,082,203 tpmC, 5.38 $/tpmC,
available 12/7/05, and HP Integrity Superdome running Oracle 10g, 1,008,144 tpmC, 8.33 $/tpmC, available 4/14/04.
SAP & SQL Server
Scalabilità a 3.5X!
Miglioramento 8X!
Nr.massimo di utenti concorrenti
Nr. di proc. per 18.000 utenti concorrenti
93,000
32
HP Integrity Superdome
26,000
SAP SD three-tier standard application benchmarks #2001016 and 2005030
HP ProLiant
4
SAP SD three-tier standard application benchmarks #2002007, and other
Grande scalabilità e ottimo rapporto prezzo/prestazioni per
l’utilizzo delle SAP business application su SQL Server 2005
SQL Server: Fewer Vulnerabilities,
Faster Response, More Secure
Database Security
Vulnerabilities
Average Days of Risk
per Vulnerability
Mar 2004-Feb 2005
Mar 2004-Feb 2005
30
61.6
38.7
32.0
7
0
Oracle 10g
MySQL 3.23
SQL Server 2000
MySQL 3.23 /
Oracle 10g /
SQL Server 2000 /
RH Ent. Linux ES 3 RH Ent. Linux ES 3Windows Server 2003
Source: “Role Comparison Security Report – Database Server Role”, published
by Security Innovation Inc. (http://www.securityinnovation.com)
.NET and Visual Studio Integration
Breakthrough in Developer Productivity
Choice of programming language
T-SQL for data-intensive functions and procedures
.NET languages for CPU-intensive functions and procedures
Choice of where to run logic
Database or mid-tier
Symmetric data access model – ADO.NET
Integrated debugging experience across
mid-tier and database tier
Seamlessly step cross-language – TSQL and .NET
Set breakpoints anywhere, inspect anything
Flexible and extensible
Users defined functions, procedures, triggers
User defined types and aggregates
XML data type
Improving organizations
by providing business
insights to all employees
leading to better, faster,
more relevant decisions
Complete and integrated BI offering
Widespread delivery of intelligence
through Microsoft Office
Enterprise grade and affordable
SSMA Early Adopter Customers
Agenda
Perchè Migrare
SQL Server 2005: Pacchettizzazioni e
prezzi
Offerte commerciali
Nota: ogni edizione include le
funzionalità delle precedenti
SQL Server 2005
prezzi e caratteristiche
Novità in SQL Server 2005
Express
Workgroup
Standard
Lo strumento più intuitivo
per sviluppare semplici
applicazioni data driven
La soluzione per
applicazioni
dipartimentali
Piattaforma completa di
gestione e analisi dei
dati per organizzazioni
medio grandi
Enterprise
Piattaforma mission
critical per applicazioni
enterprise di analisi e
gestione dei dati
4 CPU
1 CPU
1 GB RAM
4GB DB Size
3 GB RAM
Simple
Management Tool
Management
Studio
Report Wizard &
Report Controls
Import/Export
Replication &
SSB Client
Basic Reporting
Services
Free
2 CPU
Limited Replication
Publishing
Back-up Logshipping
Report BuilderBasic Reporting
Services
€ 4.725 per proc or
€914 (Server + 5 users)
Unlimited RAM
(64-bit)
Unlimited Scale
Partitioning
+
Failover clustering
Adv. DB mirroring,
Complete online &
parallel operations,
OLAP Server
DB snapshot
Report Builder Reporting Services
Advanced Analysis
Tools including full
OLAP & Data Mining
Database Mirroring
New Integration
Services
Data Mining
Full Replication &
SSB Publishing
€ 6960 per proc or
€ 2138 (Server + 5 users)
Report Builder +
Customized & High
Scale Reporting
Adv SSIS
€ 29000 per proc or
€16200 (Server + 25 users)
Agenda
Perchè Migrare
SQL Server 2005: Pacchettizzazioni e
prezzi
Offerte commerciali
Migrate to SQL Server 2005 Promo
Promozione per i clienti in possesso di:
Oracle Enterprise e Standard Edition, IBM DB2
Enterprise e Workgroup Edition (incluso
AS/400), Informix, Sybase ASE, Hitachi HiRDB,
e Fujitsu Synfoware
Sconti rispetto al prezzo completo di SQL
per la migrazione del database che
supporta un workload verso SQL Server
50% LIC EE e CAL, posto acquisto full SA
25% Lic STD, posto acquisto full SA
Ex: su due anni open 33% per EE e CAL, 17%
per STD
SA obbligatoria, solo volume license
uno SKU apposito in pricelist
Resources
http://www.microsoft.com/sql/migration
http://www.microsoft.com/sql/evaluation/compare
Michele Zoppi: [email protected]