Home

Products

Company

Contact

SVCO Extension for
Oracle SQL Developer

Overview

Download

Tutorial

Support

Tutorial

• Installing SVCO
• Using SVCO on existing schema
• Using SVCO on a new schema
• Compare two object versions

Installing SVCO

1. Start Oracle SQL Developer then select menu SVCO -> Install.
2. Select or create new connection where you would like to install SVCO, please login as SYS user.
3. Run open script (F5)
4. Because of
   Bug no 7251045 OTNFORUMS: ACCEPT DEFAULT OPTION DOES NOT WORK IN WORKSHEET
   still exists even in SQL Developer 1.5.5, you should answer (do not leave empty = default) all questions during execution of install.sql script.
5. You could uninstall SVCO selecting menu SVCO -> Uninstall.

Using SVCO on existing schema

1. Grant at least SVCO_REP_OPERATOR role to user which objects should be versioned. Granted role must be default user role. For example,
   GRANT SVCO_REP_OPERATOR TO HR;
   ALTER USER HR DEFAULT ROLE ALL;
2. Start Oracle SQL Developer then select menu SVCO -> Options.
3. Select appropriate connection, then choose Include Objects.

4. Press Add button and enter % (assuming you would like to track all HR schema objects), press OK button.

5. Select menu SVCO -> Synchronize with Repository.
6. Select appropriate connection and press OK button.
7. Choose HR and press OK button.

8. The SVCO will create initial versions for all objects in HR schema.
9. You could browse objects versions selecting menu SVCO -> Browse Object Versions.

Using SVCO on a new schema

1. Grant at least SVCO_REP_OPERATOR role to user which objects should be versioned. Granted role must be default user role. For example,
   GRANT SVCO_REP_OPERATOR TO TEST;
   ALTER USER TEST DEFAULT ROLE ALL;
2. Start Oracle SQL Developer then select menu SVCO -> Options.
3. Select appropriate connection, then choose Include Objects.

4. Press Add button and enter % (assuming you would like to track all TEST schema objects), press OK button.

5. Create any schema object as TEST user.
6. Check object version selecting menu SVCO -> Browse Object Versions.
7. Modify object, created on Step 5 to see new version tracked by SVCO – Step 6.

Compare two object versions

1. Start Oracle SQL Developer then select menu SVCO -> Browse Object Versions .
2. In "SVCO.Object Versions" window select appropriate connection.
3. Select object which has more when one version in left tree.
4. Mark object versions you would like to compare and then in popup menu select Compare Objects DDL.

5. Compare window appears.