SQL 2000 to Teradata migration

Connectivity
Enthusiast

SQL 2000 to Teradata migration

can anyone pls help me out in this subject.I have a requirement like i have to transfer a huge amount of data from SQL 2000 server to Teradata. I dont have much idea regarding this. Like if u guys tell me how i can achiev this, whether is there is any tool or simulator is there to do this or any other ways.Hoping for the genuine reply.

regards,
rakesh nc
5 REPLIES
Enthusiast

Re: SQL 2000 to Teradata migration

Hi,

There are many ways to do this.

Option 1 :
Export all sql server tables as Flat Files
Write Fastload/Multiload scripts to load data into teradata database

Option 2:
You can use DTS(external tool come along with SQL Server) to move the data from Sql server to teradata.
This migration may take more time as we are going to use ODBC connection to TERADATA.

Option3:
if your project does have any ETL tools like Informatica/Datastage then you can develop the jobs to do the data migration.

Enthusiast

Re: SQL 2000 to Teradata migration

gr8 ragu,

yes i am using DATASTAGE ETL tool.. so could u pls tell me what type of jobs i should create inorder to transfer those data from SQL to teradata. could u pls give me a clear picture of this.

and could u pls also tell me which method is having more advantages.

Enthusiast

Re: SQL 2000 to Teradata migration

Hi,
I agree with the other reply.
I have done a similar thing with Oracle. The best tool to use is Informatica.

Step to be followed:
1. Create Flat File from the SQL database.
2. Load the data in the Flat File into Teradata. You need to use Push Down Optimization option in Informatica.

It worked verywell.

-Giri.
Enthusiast

Re: SQL 2000 to Teradata migration

Open the designer

1.then drag the sQl Stage from the database
2. Give the connection properties.
3.import the Table you want to load
4.Drag the copy/Transform stage
5.Open Properties of copy/Transform stage drag required columns into output tab
6.Drag the Teradata API from Database then give the connection propeties
7.compile and run
N/A

Re: SQL 2000 to Teradata migration

What if one wants to migrate only the DB schema from SQL Server to Teradata not the User data. Does SQL server has any built-in functions that provide this functionality. How else could this be done ?