Copy tables from one Database to another Database
Moderators: chulett, rschirm, roy
Copy tables from one Database to another Database
Is there something in Datastage that can copy objects(Tables) from one database to another. If there is change in the table (example , addition of a column) in the source database , there should not be any change in the Datastage job as the whole table gets copied.
Last edited by shilpa79 on Wed Nov 08, 2006 3:38 pm, edited 1 time in total.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: Copy tables from Database to another Database
Not aware of any such things. May be you can use Database sync utilities to do such activities and not use a ETL tool to do such things.
I dont think there is a direct method of doing it in datastage
But if you really want to use datastage for it, there is a way
You can write a stored procedure to move tables from one database to another.
Call this SP from datastage!
But if you really want to use datastage for it, there is a way
You can write a stored procedure to move tables from one database to another.
Call this SP from datastage!
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's called Runtime Column Propagation and you get it in parallel jobs only.
Last edited by ray.wurlod on Thu Nov 09, 2006 8:40 am, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 83
- Joined: Sat Oct 28, 2006 6:25 am
Yes there are ways of doing it with job metadata which is called RCP (Runtime Column Propagation)
loveojha2 wrote:Runtime Column Propagation, meaning it happens at the runtime only or there are methods of doing it with the job metadata also.ray.wurlod wrote:It's called Runtime Column Propagation and you get it in parallel jobs. ...
Runtime Column Propagation is valid ONLY AFTER YOUR INITIAL TABLE STRUCTURE IS DEFINED. that means the table needs to exist on the target database and in case of any additional columns that need to be added can be done using RCP..same with server also you can use a RTI I map creation specifics to do the same functionality.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not true. If you use direct Read and Write methods, RCP will cause entire rows (all columns) to be propagated even in the absence of a schema file. That's one of the reasons it can be so dangerous! What if the rows have 5000 columns?!!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.