All Forums General
muthu1802 20 posts Joined 01/12
26 Mar 2014
How we can replicate Tables structures between 2 teradata servers ?

is there any easiest way to make sure table defintions between 2 teradata servers are in SYNC.
currently I am exporting table definitions from one server and creating tables in another server by using BTEQ & SHELL script.
 

Qaisar Kiani 337 posts Joined 11/05
02 Apr 2014

I guess there is no direct way to compare the DDLs between two different TD servers.
You can export the table definitions from both servers and using unix can find the difference in the DDLs. More or less the same approach you are doing now...

goldminer 118 posts Joined 05/09
02 Apr 2014

You could use Atana Suite Delta Tool.  Atana is like Toad for Teradata and has many tools that enhance productivity similar to your request.
 
You could SHOW the table in both environments and compare.  You could also grab the definitions in Administrator in both environments and compare in a text editor.
 
Joe

Raja_KT 1246 posts Joined 07/09
04 Apr 2014

If it is simple one and one-off situation , I think you can use script(unix/excel) to compare.
Note: You can also think that if  many more functionalities than what you require then:--  you can inquire of  unity director, loader ,mover where you can achieve synchronization by way of   SQL MULTICAST and Table Copy.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Adeel Chaudhry 773 posts Joined 04/08
08 Apr 2014

No further easy way to do so from what you are doing.
 
You can enhance the current process [if not already done] by automating the process of exporting DDLs and applying them at target server.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.