Some interesting links for developers

Printer-friendly version

Highlight some articles that have appeared lately IBM developerWorks migration between databases, and which I find particularly useful. Obviously, migration is always to DB2 database or Informix, but both descriptions of architectures and features such as the proposed methodologies can be very useful for a variety of situations and technologies.

Database Migration

How to prepare and perform a migration of a PHP application from MySQL to DB2.

Migration is from MySQL to DB2, but the article can be a good guide on steps to be taken for any migration of an application from the database that supports a new engine.

Moving a PHP application from MySQL to DB2


How to migrate a MySQL database to Informix.

The article explains the main differences between these two engines BD to be taken into account for a migration from one to another. Very interesting description of the overall architecture of the two.

The second part is a tutorial focused on the migration process, but apparently not yet available, to see if we learn when we publish and completed the post.

Figure 1. MySQL architecture overview and Processes

Each client application's request is Handled by a thread on the mysqld MySQL server side. Depending on the operation, the thread uses A Different mysqld server process to retrieve data from the database using memory. "Height =" 515 "width =" 580 "src =" http://www.ibm.com/developerworks/data/ library/techarticle/dm-1102mysqltoinnovatorc/Figure1.gif "/>

How to migrate from MySQL or PostgreSQL to DB2 Express-C

Complete description of the differences at the level of the architecture, functionality and types of data between databases MySQL and PostgreSQL open source software, and DB2 Express-C (C for Community), versionFree DB2.

This article does include the steps in the process of migration, which is based on a migration tool

Migrate from MySQL or PostgreSQL to DB2 Express-C

In the article IBM Migration Toolkit support for migrating data from MySQL to DB2 and Informix Dynamic Server can find more resources to address migration from MySQL to DB2 or Informix, this time focusing on differences at the level of useation of SQL DDL (Data Definition Language) for creating and modifying objects in the databases.

 
Google
 
     

What is Business Intelligence?
It is time to understand what exactly Business Intelligence and Business Intelligence. So, overall, usually defined as the transformation of the company data into knowledge for...
Cloud hosting, hosting to the nth degree
The cloud has now largely managed to wrap the entire ICT operation of any enterprise, from e-mail and text editing to creating an online store or backup systems. It has also...
MySQL performance improvement by adjusting some parameters
MySQL, like most database managers, to easily modify the parameters that control memory sizes engaged in certain tasks, resource utilization, concurrency limits, etc. Properly...
Anthropomorphism of BI in the enterprise
Imagine a company like a human body. Consider the elements that the human body has to make decisions. So we can easily understand the processes and tools necessary within a...
Part 09) An introduction to JDBC
In this issue I comment, to use a presentation JBDC concerned, the types of drivers that exist, such as class loading and the administrative charge. Greetings Mariano
Introduction to IBM Cognos BI, Business Intelligence suite of IBM
  IBM Cognos 8 BI suite is one of the most widely used business intelligence. Software is a fairly comprehensive, yet manageable, and one of the BI market leaders. The main...