Red Gate forums :: View topic - I want to compare two schemas in same catalogue
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK 10
SQL Comparison SDK 10 forum

I want to compare two schemas in same catalogue

Search in SQL Comparison SDK 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sastrysagi



Joined: 20 Mar 2014
Posts: 1

PostPosted: Thu Mar 20, 2014 7:34 am    Post subject: I want to compare two schemas in same catalogue Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Fri Mar 21, 2014 11:59 am    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group