Tables changes as Alter

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

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

Tables changes as Alter

Postby gjobin » Mon Mar 31, 2014 3:00 pm

Hi,

Is it possible to have the tables changes checked-in as "ALTER TABLE" in the same script instead of a complete "CREATE TABLE".

Thanks,
Guillaume
gjobin
 
Posts: 3
Joined: Thu Mar 27, 2014 8:44 pm

Postby Brian Donahue » Tue Apr 01, 2014 4:39 pm

Hello Guillaume,

Source Control's function is to create a representation of all of the objects in a schema as a series of scripts - so they will always be CREATE statements. If you need to make a synchronization script that alters objects, you can use Schema Compare for Oracle to compare the folder of CREATE scripts to a database or another folder and go through the synchronization wizard to make the script.

Hope this helps.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to Source Control for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests