Automate and integrate using the SQL comparison API
Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong
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.
- Posts: 1
- Joined: Thu Mar 20, 2014 7:21 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?
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Comparison SDK 10
Who is online
Users browsing this forum: No registered users and 0 guests