Options
Schema comparison
rsykes99
Posts: 2
I have two schema metadata that I have compared. There are 235 objects that exist in both that have differences. Let's call them schema A and schema B.
I want to generate a diff script for to review and then deploy once reviewed.
We have a vendor (schema
from which we get periodic releases. Over time we have a need to sync up our version (schema A) with theirs as it has gotten out of sync.
In our comparisons through this tool we find..
1) In some instances I want what is in schema A (our version) to take precedence. That's easy, I just check that object(s).
2) However in a lot of cases I want what is in schema B (vendor version) to be merged with what I want in schema A diff output script. How do I accomplish that in the tool?
Too add to the complexity in a 3rd case.
3) I want what is in schema B yet we have added to the same object supplemental logging on certain tables that the vendor doesn't have. I want ONLY those "alter" statements for supplemental logging from schema A (our version) added to the schema B (vendor version) object.
How do I approach this using the tool?
I want to generate a diff script for to review and then deploy once reviewed.
We have a vendor (schema
from which we get periodic releases. Over time we have a need to sync up our version (schema A) with theirs as it has gotten out of sync.In our comparisons through this tool we find..
1) In some instances I want what is in schema A (our version) to take precedence. That's easy, I just check that object(s).
2) However in a lot of cases I want what is in schema B (vendor version) to be merged with what I want in schema A diff output script. How do I accomplish that in the tool?
Too add to the complexity in a 3rd case.
3) I want what is in schema B yet we have added to the same object supplemental logging on certain tables that the vendor doesn't have. I want ONLY those "alter" statements for supplemental logging from schema A (our version) added to the schema B (vendor version) object.
How do I approach this using the tool?
