Server2000移植到DB2资源-CSDN文库

2000

Server

4星 · 超过85%的资源需积分: 9 130 浏览量 2008-03-24 16:00:24 上传评论收藏 459KB PDF 举报

资源推荐

资源详情

资源评论

Porting to DB2® Universal Database™ Version 8.2

from Microsoft

® SQL Server 2000

By Amyris V. Rada

IBM Toronto Lab

arada@ca.ibm.com

(Reprinted courtesy of developerWorks DB2, at ibm.com /developerworks/db2/)

Table of Contents

Stored Procedures

............................................................................

Triggers

.....................................................................................

Transactions

.................................................................................

ANSI Join Operators

...........................................................................

Scrollable Cursors

............................................................................

Constraints

..................................................................................

Computed Columns

...........................................................................

IDENTITY Columns

...........................................................................

Views

......................................................................................

Indexes

.....................................................................................

Temporary Tables

............................................................................

Tables

......................................................................................

SQL Standard Compliance

......................................................................

System Databases

............................................................................

Locking Mechanisms

..........................................................................

Statement Isolation Levels

......................................................................

Isolation Levels

...............................................................................

Implementation Differences ........................................................................

Database Consistency

.........................................................................

System Stored Procedures and Administrative Tools

.................................................

Tasks

......................................................................................

Online Utility Tools

............................................................................

Backup and Restore

...........................................................................

Database Security

............................................................................

Log Files

....................................................................................

Database Devices

............................................................................

Federated SQL Server 2000 Servers

..............................................................

Administration Server

..........................................................................

Environments

................................................................................

Administration Issues ..............................................................................

Data Types Conversion ............................................................................

DB2 Products

................................................................................

DB2 Application Development Client

..............................................................

DB2 Administration Client

.......................................................................

DB2 Run-Time Client Lite

.......................................................................

DB2 Run-Time Client

..........................................................................

DB2 Everyplace Edition

........................................................................

DB2 Enterprise Server Edition

...................................................................

DB2 Workgroup Server Edition

..................................................................

DB2 UDB Express Edition

......................................................................

DB2 Personal Edition

..........................................................................

DB2 Universal Database Product Family ............................................................

IBM Program for Assistance to Developers

.........................................................

High Availability Support

..........................................................................

Basic Warehousing Functionality

...................................................................

Tools for Building Web Applications

.................................................................

Integrated Web Access

..........................................................................

Integrated Support for Development Environments

.....................................................

Data Replication and Publishing

....................................................................

Self-managing and Resource Tuning

................................................................

Multiplatform tools for DB2 Universal Database

........................................................

Integrated System Management Tools

...............................................................

Integrated Support for Native Environments

..........................................................

Why Port to DB2 UDB? ...............................................................................

Introduction .........................................................................................

Introduction

Database management software is now the core of enterprise computing. Companies need access to a wide range

of information such as XML documents, streaming video, and other rich media types. New ways of working bring

new requirements, including digital rights management. The e-business evolution makes continuous availability a

necessity and is driving the convergence of transaction, business intelligence, and content management

applications as companies integrate their business operations. DB2 Universal Database (DB2 UDB) for UNIX® and

Windows® can help your organization meet these challenges.

DB2 UDB is a true cross-platform database management system (DBMS), running on a wide variety of systems

including Windows 98, Windows NT®, Windows 2000, Solaris, HP-UX, AIX®, and Linux.

DB2 UDB responds quickly to peaks in transaction demand on your Web site, expands to hold growing amounts of

information that can be distributed in a number of different databases, and grows with your information infrastructure

from one processor, to multiple processors, to massively parallel clusters. The integration of partitioning and

clustering technology into DB2 Universal Database Enterprise Server Edition (ESE) means that it is flexible enough

to meet future growth.

A real database leader in several technologies, DB2 UDB provides the following capabilities:

 Integrated support for complex data such as text documents, images, video and audio clips

 Integrated Web access through native support for Java™, Java Database Connectivity (JDBC), embedded

SQL for Java (SQLJ) and Net.Data

 Integrated system management tools

 Data replication services

 High-availability disaster recovery (HADR)

This article introduces DB2 UDB products and their capabilities, discusses porting databases and applications, and

describes the most important aspects of porting applications from Microsoft SQL Server 2000 to DB2 UDB V8.2. It

describes the differences between the two products in database options, data definition language (DDL), data

modeling, SQL considerations, data conversion, and application conversion.

All subsequent references to DB2 imply DB2 UDB for UNIX, Linux, and Windows platforms, unless otherwise

specified. All the information contained in this document is based on publicly available information as of January 06,

2005, and is subject to change. IBM disclaims all warranties as to the accuracy, completeness, or adequacy of such

information. IBM shall have no liability for errors, omissions, or inadequacies in the information contained herein or

for interpretations thereof.

Porting to DB2 UDB Version 8.2 from Microsoft SQL Server 2000 5

剩余53页未读，继续阅读

评论收藏

内容反馈

oZuoHuan1

2013-08-09

没用上，感觉一般般吧

xiaoyu_zhao1234

粉丝: 16
资源: 74

Server 2000 移植到 DB2

最新资源

Server 2000 移植到 DB2

数据库移植注意事项(SQLSERVER,ORACLE,DB2).txt

常见的关系型数据库管理系统.docx

WebSphere培训教程（完整版）

Oracle9i备课笔记——吕海东

SQLAPI++ vs2017 dll

MySQL数据库：数据库管理系统.pptx

PHP5 完整官方 中文教程

PHP5中文参考手册

FireDAC_7.0.1.3119

PHP函数参考手册大全

中文版PHP使用手册

经典收藏最全php5.0查询手册

php手册PHP5研究室编无乱码版本chm

Linux环境数据库管理员指南

PHP手册(带评论版-2008-03-14).part2.rar

绩效管理系统设计方案.doc

PHP手册(带评论版-2008-03-14).part1.rar

database-sync:数据库表同步程序，支持不同数据库间表结构和数据的同步，数据抽取

PHP5 开发手册 简体中文手册

(根据百度地图最新抓取)全国矢量地图 shp格式.zip

db2jcc4-3.71.22.jar

Toad-for-DB2-2022 7.4.12 专业IBM DB2数据库管理工具

db2数据库 v11.1版本 安装包，自测可用， 直接下载 点击安装

DB2 V10.5 linux 64位 免费版

DB2 V11.5 linux + Windows双版本下载

吉林大学DB2数据库应用程序开发 Java

吉林大学数据库系统应用开发源代码.zip

国土调查DB转照片.tbx

DB2 版本11.1下载地址

最新资源

PHP5 完整官方中文教程

PHP5 开发手册简体中文手册

db2数据库 v11.1版本安装包，自测可用，直接下载点击安装

DB2 V10.5 linux 64位免费版