Hi
A bit of background. I'm planning to maintain version control of three types of objects in oracle database across three different environment - Dev, UAT, Prod.
The way I'm going to do this is by storing the objects in to one project file (oracle database project version2 -let's call it odpv2 from now on).
and do schema compare when someone want to roll out the changes from DEV to UAT, or UAT to Production environment.
I've been trying to use this feature oracle schema compare from two different projects(created using odpv2) with no luck.
What I've found, it's able to recognize the new package that doesn't exist in target environment, but it's not able to do comparison/diff list of existing package difference in dev (vs uat).
So let's say, I have three project types (all equally created by selecting odpv2 under file > new project> oracle >).
Project A - For Development environment schema. storing one modified package, one procedure
Project B - For UAT environment schema. storing one package, one procedure
Project C - Combination of project A and B. So i can run schema compare function within this project.
something like this:
when i do schema compare project under oracle schema compare menu, in advanced selection, i checked procedure and package, and under filters tab i checked all options, and leave general tab as default.
then click OK as follow
and the result as follow
Other information that relevant are, these package/procedure objects are generated by using tool > export user objects in PL/SQL Developer, and the only differences between the two are the changes that I've made in dev package object,
and when i did the same thing for trigger object, it can't recognize it as well.
It seems to me the oracle schema compare can't perform diff listing of the two objects/ simply ignoring the changes.
Any idea ?
My detail specs as follow:
Microsoft Visual Studio Enterprise 2015
Version 14.0.25431.01 Update 3
Microsoft .NET Framework
Version 4.6.01590
Installed Version: Enterprise
Architecture and Modeling Tools 00322-90001-21205-AA065
Microsoft Architecture and Modeling Tools
UML® and Unified Modeling Language™ are trademarks or registered trademarks of the Object Management Group, Inc. in the United States and other countries.
Microsoft Visual Studio Tools for Applications 2015 00322-90001-21205-AA065
Microsoft Visual Studio Tools for Applications 2015
Visual Basic 2015 00322-90001-21205-AA065
Microsoft Visual Basic 2015
Visual C# 2015 00322-90001-21205-AA065
Microsoft Visual C# 2015
Visual C++ 2015 00322-90001-21205-AA065
Microsoft Visual C++ 2015
Application Insights Tools for Visual Studio Package 1.0
Application Insights Tools for Visual Studio
ASP.NET and Web Tools 2015.1 (Beta8) 14.1.11107.0
ASP.NET and Web Tools 2015.1 (Beta8)
ASP.NET Web Frameworks and Tools 2012.2 4.1.41102.0
For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563
ASP.NET Web Frameworks and Tools 2013 5.2.40314.0
For additional information, visit http://www.asp.net/
Chutzpah Context Menu 4.3.4
Enables you to run JavaScript unit tests via Chutzpah from the context menu
Common Azure Tools 1.8
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.
JavaScript Language Service 2.0
JavaScript Language Service
JavaScript Project System 2.0
JavaScript Project System
Microsoft Azure Mobile Services Tools 1.4
Microsoft Azure Mobile Services Tools
NuGet Package Manager 3.4.4
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.
Oracle Developer Tools for Visual Studio 12.2.0.1.0
Oracle Developer Tools for Visual Studio Copyright (c) 2005, 2017
PreEmptive Analytics Visualizer 1.2
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.
SQL Server Analysis Services 13.0.1701.8
Microsoft SQL Server Analysis Services Designer
Version 13.0.1701.8
SQL Server Data Tools 14.0.61021.0
Microsoft SQL Server Data Tools
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 13.0.1601.5
SQL Server Reporting Services 13.0.1701.8
Microsoft SQL Server Reporting Services Designers
Version 13.0.1701.8
TypeScript 1.8.36.0
TypeScript tools for Visual Studio
Visual Studio Tools for Universal Windows Apps 14.0.25527.01
The Visual Studio Tools for Universal Windows apps allow you to build a single universal app experience that can reach every device running Windows 10: phone, tablet, PC, and more. It includes the Microsoft Windows 10 Software Development Kit.
Web Analyzer 1.7.77
Provides static analysis directly in Visual Studio for JavaScript, TypeScript, JSX, CSS and more
Web Compiler 1.11.326
Compiler for LESS, Sass and CoffeeScript files
Thanks