Merge between two Databases [message #516503] |
Mon, 18 July 2011 19:39 |
|
Jefries
Messages: 3 Registered: June 2011 Location: Brazil
|
Junior Member |
|
|
Hello everybody,
In the company I work at, we have two databases: one is the Development Database, the one we work and develop procedures and triggers and so on...
The other is the Prod database, where another group of developers work, also with triggers, procedures and other Database objects...
I would like to know if it is possible to merge the differences between these two databases.
For example, let s say I have an object, a trigger on the emp table in the dev base, it's called t_emp. In the prod base I have the same object, a trigger t_emp in the same table, since the two bases must be the same, meaning, the trigger must be the same, the table, etc.
Different people will start working in the same trigger, but each team of developers will work in different bases, that is, one team in the prod base and the other in the dev.
At the end of the project we need to merge the trigger, and others objects.
We need to have both of the alterations.
How can we do that?
Is that possible? If not, is there some workaround that could do?
Tahnk you all.
|
|
|
|
|