I want to compare two schemas in same catalogue

Automate and integrate using the SQL comparison API

Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

I want to compare two schemas in same catalogue

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

Hi,

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.

Thanks,
Sastry Sagi
sastrysagi
 
Posts: 1
Joined: Thu Mar 20, 2014 7:21 am

Postby Brian Donahue » Fri Mar 21, 2014 11: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: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Comparison SDK 10

Who is online

Users browsing this forum: mpetcov and 0 guests