Home

Main Idea

How it works

Requirements

pre-Migration Process

Exporting Database

I can't explain whole processes for every RDBMS, but show an example exporting database using MS SQL Server Import and Export Wizard.

SQLServerIOWizard.png
Run SQL Server Import and Export Wizard.

SQLServerIOWizard2.png
Choose data source and database to migrate.

SQLServerIOWizard3.png
Choose excel data source, and its file name for destination

SQLServerIOWizard4.png
Success screen.

Data Cleansing

Once you succeed exporting data to excel, you need to purify data. There are several rules as below
  1. Any name of authority, container, entity name have no space, no underline. (Dash(-) is fine)
  2. The first row is field names.
  3. Sheet names are names of containers.
  4. String field should be set to text format (figure. 2)
  5. Double or Float should be set to a number format with limited decimal places (figure. 3)
  6. The first column is ID, and should be number.
  7. Entity ID is defined as "Sheet name" + "ID".
ExcelCellFormat1.gif
Figure.1 Using Format->Cells or Right-Click->Format Cells,

format_cells.gif
Figure.2

credit1.gif
Figure.3

Migration Process

post-Migration Process

Last edited Feb 24, 2009 at 9:42 PM by fkiller, version 5

Comments

No comments yet.