Generating change script for Database using SOCO

Track changes to Oracle schemas in your existing version control system.

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Generating change script for Database using SOCO

Postby raghav4192 » Mon Mar 31, 2014 3:27 pm

I was very much impressed looking at SOCO seamlessly integrating with Oracle and Subversion.

In my organization, developers cannot apply Oracle changes and is streamlined through a group of DBA. As in this case, if I would like to apply changes made in Subversion to a DB can SOCO generate the change script to be handed over to the DBA group.

Also in a release process, changes in Subversion will first be applied to test DB and then to Quality DB and then to pre-production and Production DB. How does SOCO help to connect changes checked in a single subversion url to multiple Oracle DB instances ??

Answers to this questions will be key for us to pursue using Redgate SOCO.
raghav4192
 
Posts: 1
Joined: Mon Mar 31, 2014 3:22 pm

Postby eddie davis » Tue Apr 01, 2014 4:58 pm

Hi, thank you for your forum post.

To answer your questions:

In my organization, developers cannot apply Oracle changes and is streamlined through a group of DBA. As in this case, if I would like to apply changes made in Subversion to a DB can SOCO generate the change script to be handed over to the DBA group.


SOCO will not generate a change script that you can then pass to a group of people. A sister product called Schema Compare for Oracle will help you, as you a compare a schema with a scripts folder and generate a deployment script.

SOCO, allows a person to make changes to a schema and check this changes into source control. The schema can be dedicated schema to that individual or a schema that all developers have access to.

Also in a release process, changes in Subversion will first be applied to test DB and then to Quality DB and then to pre-production and Production DB. How does SOCO help to connect changes checked in a single subversion url to multiple Oracle DB instances ??


In theory, you would have project for each schema in test, quality, pre-production and production connected to the same URL. If a developer is working on the test schema, he can lock the objects that he is working with.

I recommend that you contact our Sales Team [sales@red-gate.com], who will be able demonstrate SOCO and the other Oracle tools to you.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to Source Control for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests