|
|
|
Junior Member
 
Group: Forum Members
Last Login: 8/14/2008 7:50:18 AM
Posts: 11,
Visits: 34
|
|
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
Rakesh nc
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 8/25/2008 8:43:10 AM
Posts: 16,
Visits: 9
|
|
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.
Ragu
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 8/14/2008 7:50:18 AM
Posts: 11,
Visits: 34
|
|
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.
Rakesh nc
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/7/2007 2:45:00 PM
Posts: 6,
Visits: 1
|
|
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.
Thanks, Giri.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 5/4/2008 5:49:20 AM
Posts: 17,
Visits: 21
|
|
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
Praneet
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/18/2007 3:33:00 AM
Posts: 1,
Visits: 1
|
|
|
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 ?
|
|
|
|