Teradata Forums / Drivers and UDFs / Teradata / SQL 2000 to Teradata migration / Latest Posts

RE: SQL 2000 to Teradata migration

Usama — Thu, 13 Sep 2007 03:21:53 GMT

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 ?

RE: SQL 2000 to Teradata migration

Praneet Kulkarni — Tue, 07 Aug 2007 09:25:57 GMT

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

RE: SQL 2000 to Teradata migration

Giri_tdm — Sun, 29 Jul 2007 22:29:28 GMT

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.

RE: SQL 2000 to Teradata migration

Rakesh nc — Thu, 21 Jun 2007 09:32:24 GMT

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.

RE: SQL 2000 to Teradata migration

ragugct — Thu, 21 Jun 2007 05:28:25 GMT

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.

SQL 2000 to Teradata migration

Rakesh nc — Wed, 13 Jun 2007 04:45:43 GMT

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