I am using the Oracle Developer tools for Visual Studio 2019 and connected to a Oracle 12.1 database using the Oracle Database (ODP.NET, Managed Driver) provider
Example:
View definition from Oracle SQL DEVELOPER
CREATE OR REPLACE FORCE EDITIONABLE VIEW "XXX"."VW_YYY_INFO" ("SOME_ID", "SOME_NAME") AS
select distinct otherID, othername
from some_table;
When doing a Import Schema the definition imported into the Developer tools project is:
CREATE OR REPLACE VIEW "XXX"."VW_YYY_INFO" AS
select distinct otherID, othername
from some_table;
The FORCE EDITIONABLE and the column name definition is removed
When doing a Schema compare the tool report differences:
Only in Source
otherID and othername
Only in Target
SOME_ID and SOME_NAME
The compare tool also have many views which has the Compare Status "Not Compared"
Am I using the correct provider. Some settings that I have overlooked?