Data retention and data migration in the V1.2 Administrator of data Studio

Use the data Studio Administrator to preserve and migrate information during complex database changes

Introduction: Do you need to make complex changes to the database? For example, the column is moved to another table while the original data is preserved. By using the data Studio Administrator for Db2®for linux®, UNIX®, and Windows® (that is, the previous DB2 change Management Expert), you can make complex changes to the database Retain valuable data even more. This article learns a scenario in which the DBA uses data Studio Administrator to create a new table, and then populate the new table with the information from the existing table.

Note: This article is an update on an article about DB2 change Management Expert. This article describes IBM Data Studio Administrator for DB2 for Linux, UNIX, and Windows, and other changes available in Data Studio Administrator Version 1.2 Of.

Brief introduction

This article demonstrates how a DBA in a fictitious company, JK Enterprises, uses IBM data Studio Administrator to make changes to the DB2 database while preserving the data. The DBA also uses Data Studio Administrator to validate and test changes on the target model before deploying the target model to the production database.

First, review the steps that Data Studio Administrator will help you perform when making complex changes:

Quickly identify database objects to change through a rich, interactive user interface

Create a deployment script to manage changes

Implement these changes on a model

Identify which views, functions, procedures, and triggers will not work after the change, and which views, functions, procedures, and triggers will work after they are changed

Use deployment scripts to generate SQL to apply changes

Use export and Import commands to preserve data

Deploying changes to a database

Prerequisite

This scenario uses Data Studio Administrator Version 1, Release 2. To complete this scenario, you must have the Data Studio Administrator installed on your computer (see Resources section).

Important: This scenario uses the Dsademo database. You can download the Sample02.zip file from the download section of this article and unzip it to a local directory, and then install the data Definition Language (DDL) (CREATEDSADEMO.CHX) to create and set up the database. The following steps are set up for this database:

Select File > Import > General > Existing Projects into Workspace to import a project named Test from Sample02.zip.

Click Select Archive file to find the location of the sample02.zip. In the Project field, click the check box next to test.

Figure 1. Import a project into the workspace