Generating change script for Database using SOCO

• 
  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 D April 01, 2014 11:58

  - 0 +

Add comment

Please sign in to leave a comment.