I want to compare two schemas in same catalogue

Automate and integrate using the SQL comparison API

I want to compare two schemas in same catalogue

Postby sastrysagi » Thu Mar 20, 2014 6:34 am


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
Posts: 1
Joined: Thu Mar 20, 2014 6:21 am

Postby Brian Donahue » Fri Mar 21, 2014 10:59 am

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?
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests