Hi,

I am working on migrating many Oracle tables to SQL server 2000 and
performing column level transformations for most the tables.

I am first planning to export all the Oracle tables to a staging
database in the SQL server 2000. Then apply transforms for the tables
and export it onto the target SQL server database.

I am planning to use DTS for the migrations. I have some basic
questions regarding DTS features:

1. There are different approaches in DTS for migrating:

a. Using the Import/Export wizard.

b. Data transform task/Data driven task.

c. Programmatically using VB application and accessing the DTS
libraries


In option b, we can use Active x scripts for performing the
transformations by creating a package.

Questions:

1. Is Data transform task sufficient for my purpose? Is there any way
Data Driven Query task can help me in this regard? Also the same for
Parallel Data dump task? I have not read much abt Parallel data dump
task, hence the query?

2. Is there any way T SQL help me in this regard if I go for Data
transform task option?

2. I also feel that I need not go for VB application in this regard.
Any comments regarding whether it is better suited than a data
transform task will help me too.

3. Regarding creation of packages, should I create multiple packages
for migrating each table from staging database and then link all the
packages using conditions or a single package is fine? Will there be
any performance implications in first case?

Thanks in advance,

Pradip

what type of transformations do you need?

<pradip1979 (AT) yahoo (DOT) com> wrote

Transformations are of following kind:

1. Direct copy source columns to target
2. Merge columns from multiple source tables onto a single target table
3. copy source columns of 1 table onto columns on multiple target
tables

Rgds,
Pradip

I think you can create SQL queries and use the datapump task to improve the
loading performance.

don't use the DDQ (datadriven query task) which do a row by row load. the
datapump do a bulk insert (thousand rows by second)


"prad79" <pradip1979 (AT) yahoo (DOT) com> wrote