Tables changes as Alter

gjobin

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

Brian Donahue

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.