Migrating from Microsoft SQL Server to IBM Informix Migrating from Microsoft SQL Server to IBM Informix

Migrating from Microsoft SQL Server to IBM Informix

Lời Giới Thiệu Của Nhà Xuất Bản

In this IBM® Redbooks® publication, we discuss considerations, and describe a methodology, for transitioning from Microsoft® SQL Server 2008 to the Informix® Dynamic Server. We focus on the topic areas of data, applications, and administration, providing information about the differences in features and functionality, including the data types, data manipulation language, data definition language, and stored procedures. Understanding the features and functionality of the two products assists you in developing a migration plan.

We provide a conversion methodology and discuss the processes for migrating the database objects and data from SQL Server to Informix using various methods. We show the SQL differences between SQL Server and Informix and illustrate, with examples, how to convert tables, views, stored procedures, functions, and triggers. We provide script conversion samples for data loading. We describe application programming and conversion considerations. In addition, we discuss the Informix configuration, as well as the administration features and functions Informix provides to help DBAs manage the Informix database server after it is migrated.

With this information, you can develop your required transition methodology, and you can plan and execute the conversion activities in an orderly and cost-effective manner.

THỂ LOẠI
Máy Vi Tính & Internet
ĐÃ PHÁT HÀNH
2010
22 tháng 7
NGÔN NGỮ
EN
Tiếng Anh
ĐỘ DÀI
496
Trang
NHÀ XUẤT BẢN
IBM Redbooks
NGƯỜI BÁN
International Business Machines Corp
KÍCH THƯỚC
2,3
Mb
IBM Informix Developer's Handbook IBM Informix Developer's Handbook
2010
Microsoft SQL Server 2008 Bible Microsoft SQL Server 2008 Bible
2011
Data Warehousing with the Informix Dynamic Server Data Warehousing with the Informix Dynamic Server
2009
MySQL to DB2 Conversion Guide MySQL to DB2 Conversion Guide
2009
SQL SQL
2020
Professional Microsoft SQL Server 2012 Administration Professional Microsoft SQL Server 2012 Administration
2012
Advanced Networking Concepts Applied Using Linux on IBM System z Advanced Networking Concepts Applied Using Linux on IBM System z
2012
Integrated Law Enforcement: A Holistic Approach to Solving Crime Integrated Law Enforcement: A Holistic Approach to Solving Crime
2014
IBM System Blue Gene Solution: Blue Gene/Q Hardware Installation and Maintenance Guide IBM System Blue Gene Solution: Blue Gene/Q Hardware Installation and Maintenance Guide
2013
WebSphere Application Server V7 Administration and Configuration Guide WebSphere Application Server V7 Administration and Configuration Guide
2010
Implementation of IBM j-type Ethernet Appliances Implementation of IBM j-type Ethernet Appliances
2011
System z Mean Time to Recovery Best Practices System z Mean Time to Recovery Best Practices
2010
IBM PowerVM Virtualization Introduction and Configuration IBM PowerVM Virtualization Introduction and Configuration
2017
Configure MSSQL Server Configure MSSQL Server
2017
Implementing an IBM / Cisco SAN Implementing an IBM / Cisco SAN
2009
VersaStack Solution by Cisco and IBM with SQL, Spectrum Control, and Spectrum Protect VersaStack Solution by Cisco and IBM with SQL, Spectrum Control, and Spectrum Protect
2015
MySQL to DB2 Conversion Guide MySQL to DB2 Conversion Guide
2009
Getting Started with IBM API Connect: Scenarios Guide Getting Started with IBM API Connect: Scenarios Guide
2016