Upgrade Oracle database from TFS scripts
Posted: Thu 26 Jun 2014 19:19
Hi,
We are trying to come up with an automated process of upgrading an oracle database.
Basically, we keep all the scripts (tables, views, stored procs, static data, etc) in TFS.
Is it possible to create a snapshot and .dcomp file from those scripts?
So that we can run the schema compare and data compare from command line and hence upgrade the target database.
Any thoughts or ideas?
Thanks,
Radha
We are trying to come up with an automated process of upgrading an oracle database.
Basically, we keep all the scripts (tables, views, stored procs, static data, etc) in TFS.
Is it possible to create a snapshot and .dcomp file from those scripts?
So that we can run the schema compare and data compare from command line and hence upgrade the target database.
Any thoughts or ideas?
Thanks,
Radha