Data Migration
Process
Data
migration is the process of migrating data from one database to another database
(i.e importing data from source db to target db) by mapping the fields of
source and destination tables respectively.
Here we followed the process using SQL server integration
tool (i.e DB to DB importing process )
à
Open Visualstudio select new project Templates > Business Intelligence >Integrated
services
àIn
integrated services >select the Solution Explorer >Go to SSIS Packages
>new Package >rename the package
àOn
the left hand side select the dataflow >drag & drop the OLE DB source
component and OLE DB destination component.
àNow
goto OLE DB Source> double click on it > Select the server name, database
name & table name (i.e from this server, database & table, the data is
ready to import on destination) then click ok
Note:
while clicking ok please check the columns are marked or not
Example: Here we selected servername as
INSVR07, DB as TTC_2009, Sales Table, check test connection whether the
connection is succeeded or not
àSelect
the Source component, map it to the destination component (i.e select source
component then one blue down arrow appears on it just simply drag it on the
destination component)
àNow
Double Click on the destination > Select the server name, database name
& table name (i.e to this server, database, table the data is going to
import from the source) now click on mapping and Map the both fields and click
ok
Example: Here we selected servername as INSVR07,
DB as TTC_2012, Sales Table, check test connection whether the connection is
succeeded or not
àif
any error symbols shows it means mapping doesn’t done correctly or if no any
errors occurs mapping was done successfully
àFinally,
Select both source and destination components then right click > Select
execute Task
If it shows any
error occurs check it in process tab.
àNow
the data is imported from source to destination tables
