Re: database source control? dbmaestro, Red Gate, Datical

I've been at sights where all the developers share one copy of the production database and any time they want to try out a change to the schema it's a 1-2 week code review to make sure they don't mess up the other developers using that one copy. I don't know about you but that would kill my motivation.

The other end of the spectrum, which is way better in my opinion for efficiency, is giving each developer a copy so they can work as fast as they want without impacting others. Now the problem comes of how do you track and merge changes? What I've seen of DBmaestro is great. Red Gate also has a product like this.

DBmaestro can track the changes in multiple copies of a database, so I can have a trunk, compare all my developers to this trunk and track and merge changes into this trunk copy. All the while generating upgrade scripts for prod.

• Kyle

On Fri, Jul 18, 2014 at 10:08 PM, Justin Mungal <justin_at_n0de.ws> wrote:

> *dumb non-dba-dev question*
>
> Don't you guys just store the source for your procedures and such in sql
> files rather than editing them from the DB?
>
>
> On Sat, Jul 19, 2014 at 2:58 AM, Mohamed Houri <mohamed.houri_at_gmail.com>
> wrote:
>
>> The cool thing also about DBmaestro is that (according to a Webinar I
>> have followed)
>>
>>
>> - it is plugged with SQLDeveloper
>> - when a database object is checked out from SQLDeveloper (for
>> example) you can't access it from SQL*Plus (or from another tool)
>>
>> Best regards
>> Mohamed Houri
>> www.hourim.wordpress.com
>>
>>
>>
>> 2014-07-18 22:35 GMT+02:00 kyle Hailey <kylelf_at_gmail.com>:
>>
>>
>>> The cool thing about DBmaestro that I've been looking at, is you
>>>
>>>
>>> - check objects out
>>> - compare different databases
>>> - Compare two databases to a third baseline
>>> - Produce rollout and upgrade scripts
>>>
>>>
>>> I think that would be hard with home grown tools
>>>
>>>
>>>
>>>
>>> On Fri, Jul 18, 2014 at 9:26 AM, rjamya <rjamya_at_gmail.com> wrote:
>>>
>>>> None, we built a homegrown solutions around Liquibase and it works very
>>>> well for us.
>>>>
>>>> Raj
>>>> On Jul 18, 2014 3:06 PM, "kyle Hailey" <kylelf_at_gmail.com> wrote:
>>>>
>>>>>
>>>>> Is anyone using DBmaestro, Red Gate Source Control for Oracle or
>>>>> Datical to manage database source control such as schema, pl/sql, metadata
>>>>> source control?
>>>>>
>>>>> Experiences, thoughts?
>>>>>
>>>>> Thanks
>>>>> Kyle
>>>>>
>>>>>
>>>
>>
>>
>> --
>>
>> Houri Mohamed
>>
>> Oracle DBA-Developer-Performance & Tuning
>>
>> Member of Oraworld-team <http://www.oraworld-team.com/>
>>
>> Visit My - Blog <http://www.hourim.wordpress.com/>
>>
>> Let's Connect - <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin
>> Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*
>>
>> My Twitter <https://twitter.com/MohamedHouri> - MohamedHouri
>> <https://twitter.com/MohamedHouri>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l