SQL_Server_to_SQL_Server_PDW_Migration_Guide.pdf

(1565 KB) Pobierz
SQL Server
to SQL
Server PDW
Migration Guide
(AU3)
Contents
4
4
Summary Statement
Introduction
4
6
8
10
SQL Server Family of Products
Differences between SMP and MPP
PDW Software Architecture
PDW Community
10
Migration Planning
11
11
12
Determine Candidates for Migration
Migration Considerations
Migration Approaches
13
SQL Server to PDW Migration
13
13
14
14
20
Main Migration Steps
PDW Migration Advisor
APS Migration Utility
Table Geometry
Optimization within PDW
Microsoft SQL Server to SQL Server PDW Migration Guide (AU3)
29
Converting Database Schema Objects
29
36
Type Mapping
Syntax Differences
51
51
51
52
Conclusion
For More Information
Feedback
Appendix
Microsoft SQL Server to SQL Server PDW Migration Guide (AU3)
© 2014 Microsoft Corporation. All rights
reserved. This document is provided “as-is.”
Information and views expressed in this
document, including URL and other Internet
Web site references, may change without
notice. You bear the risk of using it. This
document does not provide you with any legal
rights to any intellectual property in any
Microsoft product. You may copy and use this
document for your internal, reference
purposes. You may modify this document for
your internal, reference purposes.
Microsoft SQL Server to SQL Server PDW Migration Guide (AU3)
Summary
Statement
In this migration guide you will learn the differences between the
SQL Server and Parallel Data Warehouse database platforms, which
runs on the Analytics Platform System appliance, and the steps
necessary to convert a SQL Server database to Parallel Data
Warehouse.
This guide has been updated to reflect the T-SQL improvements
contained within Version 2, Appliance Update 3 (AU3)
Introduction
Migrating a data warehouse application from Microsoft
®
SQL Server
®
SMP to the Microsoft
®
SQL Server
®
Parallel Data Warehouse (PDW)
region within the Microsoft Analytics Platform System (APS) appliance,
provides many benefits, including improved query performance,
scalability and the simplest integration to Hadoop.
This white paper explores the remediation activities and provides
guidance to overcome technical differences between the two database
platforms in order to simplify migration projects. It describes the
implementation differences of database objects, SQL dialects, and
procedural code between the two platforms.
SQL Server
Family of
Products
Microsoft offers a wide range of SQL Server products to accommodate
the different business needs and technical requirements to provide a
robust and scalable enterprise-wide solution.
Compact Edition
Microsoft SQL Server Compact 4.0 is a compact database ideal for
embedding in desktop and web applications. SQL Server Compact 4.0
gives developers a common programming model with other SQL Server
editions for developing both native and managed applications. SQL
Server Compact provides relational database functionality in a small
footprint.
Express Edition
SQL Server 2014 Express Edition is available for free from Microsoft and
provides a powerful database engine ideal for embedded applications or
for redistribution with other solutions. Independent software vendors
use it to build desktop and data-driven applications. If you need more
advanced database features and support for greater than 10 GB
databases, SQL Server Express is fully compatible with other editions of
SQL Server can be seamlessly upgraded to enterprise versions of SQL
Microsoft SQL Server to SQL Server PDW Migration Guide (AU3)
4

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin