Tables changes as Alter

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

Tables changes as Alter

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


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

Posts: 3
Joined: Thu Mar 27, 2014 7:44 pm

Postby Brian Donahue » Tue Apr 01, 2014 3: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: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to Source Control for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests