Forum Stats

  • 3,758,932 Users
  • 2,251,475 Discussions
  • 7,870,439 Comments

Discussions

sqlcl database diff?

Ron Fancher
Ron Fancher Member Posts: 29
edited Aug 2, 2018 3:20AM in SQLcl

Is there a way to run a database diff from SQLCL? I haven't been able to find it in the documentation and didn't come up with much googling it. Today we load a schema with our current DDL and a second schema with the DDL after requested changes, and then go to SQL Developer --> Tools --> Database diff to help test our work. I'd like to be able to automate that via SQLCL.

Answers

  • User_IKAHD
    User_IKAHD Member Posts: 2 Red Ribbon
    edited Aug 2, 2018 3:20AM

    The best answer is DIY.

    some idea's to get you started:

    - create a central database (where you can connect to all others)

    - use the bridge command to sync the dba_ or all_ tables that you require for each environment; to create a local copy (add version or date name)

    - compare with minus/intersect ... whatever your requirement are

    - script the whole thing. (I would make it date based)

    - cleanup after x days (retention period)