What are the challenges you face when working across database platforms? Take the survey

I want to compare two schemas in same catalogue

sastrysagisastrysagi Posts: 2

I have a Master Schema and I am trying to copy the same schema for every customer with in the same database catalogue to ease the customization for the customer.. Is there any solution for synchronizing the master schema to new schema. If we do any incremental changes to the Master Schema, we need to synchronize those changes to the other schemas.

Please provide me the details.

Sastry Sagi


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    I'm afraid I do not completely understand your requirement.

    I think it is: You have a template schema "master schema" that you use as a template to update other schemas in the same database. And by schema, you do not mean the schema object, you mean a group of objects that are organized under different schema names in the same database.

    So you want to apply changes in objects you make in the "master schema" to all other schemas.

    You could use schema mapping, but that has a 1:1 relationship and will not map more than one schema to the master. So I guess the solution would be to map "master" to one "user", filter out all other "user"s and do several comparisons this way.

    Does that sound like what you want to do?
Sign In or Register to comment.