Hello , I need to compare and then replicate object between two systems, Actual Prod and DR. Is there a way to identify missing /out of sync objects in DR system ?
as stated above:
AtanaSuite, good third party tool, offers this functionality.
If you are going to use Unity in the future you should also be able overcome this issue.
Otherwise compare dbc content, where this can become tricky in some areas - there exists more posts on this question in the form.
So, what is your real question?
Thank you Ulrich, question is to keep the DR system in sync with production system . We have unity director and Dataloader. can you explain what functionality in unity supports object sync between systems. How do we keep objects definitions in sync (currently out of sync)
looking if there is any automated process / manual script to do the comparison.
I am doing this with a Unix shell script which exports all object definitions to flat files considering differences between Teradata Releases.
In a second step I use Beyond Compare (http://www.scootersoftware.com) - they have a 30 day trial version - to compare the objects.
This approach is really fast and convinient for me. The shell script I can send you (send me a message).