|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/8/2009 3:12:12 PM
Posts: 5,
Visits: 12
|
|
Hi,
How to fetch the data from one server and insert in to other server in SQL Assistance?
e.g
If my source table and target table is in same server, i can do the following
Insert into retail.test_table_Tgt
Select * from retail.test_table_src
How can i do the above, if my source table and target table are different servers without any ETL job?
Can we do it using stored procedures? Please help me to get the syntax...
VHLU4C
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: 11/2/2009 12:55:57 PM
Posts: 74,
Visits: 196
|
|
Won't be possible using stored procedure..
You need to go for scripting which will inturn call fastload or mload.
Regards,
Subhash
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/8/2009 3:12:12 PM
Posts: 5,
Visits: 12
|
|
HI Subhash,
In Oracle we can do that using DBLINK,is there any thing like that in Teradata?
VHLU4C
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/22/2009 1:29:06 AM
Posts: 36,
Visits: 182
|
|
Hi,
As far as I know, there is no dblink in teradata like in oracle. but work arounds are always there.... :)
Fastexport ...ftp....and then mload or tpump..... :). Anyone who knows better please suggest. Hope I can speak
to Teradata soon :)
Thanks and regards,
Raja
Teradata_cert_Oracle_cert
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/29/2009 11:35:27 AM
Posts: 1,
Visits: 10
|
|
You can export the results in text file from Teradata SQL assistant from Source server.
SELECT * FROM ABC;
Log-in to the target server and import the results from file while running the command below
INSERT INTO TABLE ABC VALUES('?','?','?'); --Assuming there are 3 character columns.
** Exporting and importing option is available in the File menu of Teradata assistant
Sachin
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/30/2009 6:28:19 AM
Posts: 34,
Visits: 117
|
|
Raja is correct - there is no option in Teradata to load data from one server to another.
If data volume is less, then you can use the same process as mentioned by Sachin.
But in this case - you've to do manually everytime - dynamically it's not possible.
Better to export & then import [ here also you may face some problem :-) ]
Similar case I had to do in my current project - I've tried this option - but delimiter is always causes problem.
As we had a option to use ETL tool - we went for that to load - it was easy.
If any solutions found - please post...
Regards,
ANIMESH DUTTA
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/21/2009 4:47:49 PM
Posts: 7,
Visits: 29
|
|
three solutions:
1.Do EXPORT/IMPORT using SQL assistant.
2.Do FASTEXPORT/FASTLOAD from source to target system.
3.Do source table backup and then restore it on the target system.
|
|
|
|