MIGRATION_WORKBENCH.MGV_ALL_CAPTURED_SQL

General Info

Caption MGV_ALL_CAPTURED_SQL

Body
AS
SELECT d."OBJTYPE",d."OBJNAME",d."OBJID",d."MAINOBJTYPE",d."MAINOBJNAME",d."MAINOBJID",d."SCHEMANAME",d."SCHEMAID",d."CATALOGNAME",d."CATALOGID",d."CONNNAME",d."CONNID",d."PROJECTNAME",d."PROJECTID",d."CAPTUREDORCONVERTED",d."QUALIFIEDNAME", p.native_sql,p.linecount
FROM md_stored_programs p , mgv_all_programs_details d
WHERE p.id = d.objid
AND d.capturedorconverted = 'CAPTURED'
UNION ALL
SELECT d."OBJTYPE",d."OBJNAME",d."OBJID",d."MAINOBJTYPE",d."MAINOBJNAME",d."MAINOBJID",d."SCHEMANAME",d."SCHEMAID",d."CATALOGNAME",d."CATALOGID",d."CONNNAME",d."CONNID",d."PROJECTNAME",d."PROJECTID",d."CAPTUREDORCONVERTED",d."QUALIFIEDNAME",v.native_sql,v.linecount
FROM md_views v , mgv_all_view_details d
WHERE v.id = d.objid
AND d.capturedorconverted = 'CAPTURED'
UNION ALL
SELECT d."OBJTYPE",d."OBJNAME",d."OBJID",d."MAINOBJTYPE",d."MAINOBJNAME",d."MAINOBJID",d."SCHEMANAME",d."SCHEMAID",d."CATALOGNAME",d."CATALOGID",d."CONNNAME",d."CONNID",d."PROJECTNAME",d."PROJECTID",d."CAPTUREDORCONVERTED",d."QUALIFIEDNAME" ,t.native_sql,t.linecount
FROM md_triggers t , mgv_all_trigger_details d
WHERE t.id = d.objid
AND d.capturedorconverted = 'CAPTURED'

View Properties

Aliases "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME","NATIVE_SQL","LINECOUNT"

 

MIGRATION_WORKBENCH.MGV_ALL_CATALOG_DETAILS

General Info

Caption MGV_ALL_CATALOG_DETAILS

Body
AS
SELECT 'MD_CATALOGS' objtype, cat.catalog_name objname, cat.id objid, 'MD_CATALOGS' MainObjType,cat.catalog_name MAINOBJNAME, cat.id MAINOBJID,null SchemaName,null schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id connid,proj.project_name projectname,proj.id projectid,
NVL(conn.type,'CAPTURED') CapturedOrConverted,
CASE WHEN conn.type IS NULL THEN cat.catalog_name ELSE NULL END QualifiedName
FROM MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
WHERE cat.connection_id_fk = conn.id
AND conn.PROJECT_ID_FK = proj.id

View Properties

Aliases "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME"

 

MIGRATION_WORKBENCH.MGV_ALL_CATALOGS

General Info

Caption MGV_ALL_CATALOGS

Body
AS
SELECT md_projects.id project_id ,
md_projects.project_name project_name,
md_connections.id connection_id ,
md_connections.host host ,
md_connections.port port ,
md_connections.username username ,
md_connections.dburl dburl ,
md_catalogs.id catalog_id ,
md_catalogs.catalog_name catalog_name
FROM md_projects ,
md_connections,
md_catalogs
WHERE md_catalogs.connection_id_fk = md_connections.id
AND md_connections.project_id_fk = md_projects.id

View Properties

Aliases "PROJECT_ID","PROJECT_NAME","CONNECTION_ID","HOST","PORT","USERNAME","DBURL","CATALOG_ID","CATALOG_NAME"
Create View With These Restriction Read Only

 

MIGRATION_WORKBENCH.MGV_ALL_COLUMN_DETAILS

General Info

Caption MGV_ALL_COLUMN_DETAILS

Body
AS
SELECT 'MD_COLUMNS' objtype, c.COLUMN_NAME objname, c.Id objid, 'MD_TABLES' MainObjType,t.table_name MAINOBJNAME, t.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id connid,proj.project_name projectname,proj.id projectid,
NVL(conn.type,'CAPTURED') CapturedOrConverted,
CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||t.table_name ||'.'||c.COLUMN_NAME QualifiedName
FROM MD_COLUMNS c, MD_TABLES t,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
WHERE c.table_id_fk = t.id
AND t.schema_id_fk = s.id
AND s.catalog_id_fk = cat.id
AND cat.connection_id_fk = conn.id
AND conn.PROJECT_ID_FK = proj.id

View Properties

Aliases "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME"

 

MIGRATION_WORKBENCH.MGV_ALL_COLUMNDT_DETAILS

General Info

Caption MGV_ALL_COLUMNDT_DETAILS

Body
AS
SELECT 'MD_COLUMNS' objtype, c.COLUMN_NAME objname, c.Id objid, 'MD_TABLES' MainObjType,t.table_name MAINOBJNAME, t.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id connid,proj.project_name projectname ,proj.id projectid,
NVL(conn.type,'CAPTURED') CapturedOrConverted,
CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||t.table_name ||'.'||c.COLUMN_NAME QualifiedName,
c.column_type datatype,
CASE WHEN p.PROP_KEY='SEEDVALUE' THEN 'Y' ELSE 'N' END IsIdentity
FROM MD_COLUMNS c LEFT OUTER JOIN MD_ADDITIONAL_PROPERTIES p ON c.id =p.ref_id_fk
, MD_TABLES t,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn,MD_PROJECTS proj
WHERE c.table_id_fk = t.id
AND t.schema_id_fk = s.id
AND s.catalog_id_fk = cat.id
AND cat.connection_id_fk = conn.id
AND conn.PROJECT_ID_FK = proj.id

View Properties

Aliases "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME","DATATYPE","ISIDENTITY"

 

MIGRATION_WORKBENCH.MGV_ALL_CONNECTIONS

General Info

Caption MGV_ALL_CONNECTIONS

Body
AS
SELECT md_projects.id project_id ,
md_projects.project_name project_name,
md_connections.id connection_id ,
md_connections.host host ,
md_connections.port port ,
md_connections.username username ,
md_connections.dburl dburl
FROM md_projects,
md_connections
WHERE md_connections.project_id_fk = md_projects.id

View Properties

Aliases "PROJECT_ID","PROJECT_NAME","CONNECTION_ID","HOST","PORT","USERNAME","DBURL"
Create View With These Restriction Read Only

 

MIGRATION_WORKBENCH.MGV_ALL_CONSTRAINTS_DETAILS

General Info

Caption MGV_ALL_CONSTRAINTS_DETAILS

Body
AS
SELECT 'MD_CONSTRAINTS' objtype, c.name objname, c.Id objid, 'MD_TABLES' MainObjType,t.table_name MAINOBJNAME, t.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id connid,proj.project_name projectname,proj.id projectid,
NVL(conn.type,'CAPTURED') CapturedOrConverted,
CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||t.table_name ||'.'||c.name QualifiedName
FROM MD_CONSTRAINTS c, MD_TABLES t,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
WHERE c.table_id_fk = t.id
AND t.schema_id_fk = s.id
AND s.catalog_id_fk = cat.id
AND cat.connection_id_fk = conn.id
AND conn.PROJECT_ID_FK = proj.id

View Properties

Aliases "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME"

 

MIGRATION_WORKBENCH.MGV_ALL_DETAILS

General Info

Caption MGV_ALL_DETAILS

Body
AS
SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_CATALOG_DETAILS
UNION
SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_SCHEMA_DETAILS
UNION
SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_TABLES_DETAILS
UNION
SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_COLUMN_DETAILS
UNION
SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_CONSTRAINTS_DETAILS
UNION
SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_INDEX_DETAILS
UNION
SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_TRIGGER_DETAILS
UNION
SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_VIEW_DETAILS
UNION
SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_PROGRAMS_DETAILS

View Properties

Aliases "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME"

 

MIGRATION_WORKBENCH.MGV_ALL_INDEX_DETAILS

General Info

Caption MGV_ALL_INDEX_DETAILS

Body
AS
SELECT 'MD_INDEXES' objtype,i.index_name objname, i.Id objid, 'MD_TABLES' MainObjType,t.table_name MAINOBJNAME,t.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id connid, proj.project_name projectname,proj.id projectid,
NVL(conn.type,'CAPTURED') CapturedOrConverted,
CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||i.index_name QualifiedName
FROM MD_INDEXES i, MD_TABLES t,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn,MD_PROJECTS proj
WHERE i.table_id_fk = t.id
AND t.schema_id_fk = s.id
AND s.catalog_id_fk = cat.id
AND cat.connection_id_fk = conn.id
AND conn.PROJECT_ID_FK = proj.id

View Properties

Aliases "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME"

 

MIGRATION_WORKBENCH.MGV_ALL_PROGRAMS_DETAILS

General Info

Caption MGV_ALL_PROGRAMS_DETAILS

Body
AS
SELECT 'MD_STORED_PROGRAMS' objtype,p.name objname, p.Id objid, 'MD_STORED_PROGRAMS' MainObjType,p.name MAINOBJNAME,p.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id connid,proj.project_name projectname,proj.id projectid,
NVL(conn.type,'CAPTURED') CapturedOrConverted,
CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||p.name QualifiedName
FROM MD_STORED_PROGRAMS p,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
WHERE p.schema_id_fk = s.id
AND s.catalog_id_fk = cat.id
AND cat.connection_id_fk = conn.id
AND conn.PROJECT_ID_FK = proj.id

View Properties

Aliases "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME"

 

MIGRATION_WORKBENCH.MGV_ALL_SCHEMA

General Info

Caption MGV_ALL_SCHEMA

Body
AS
SELECT md_projects.id project_id ,
md_projects.project_name project_name,
md_connections.id connection_id ,
md_connections.host host ,
md_connections.port port ,
md_connections.username username ,
md_catalogs.id catalog_id ,
md_catalogs.catalog_name catalog_name,
md_schemas.id schema_id ,
md_schemas.name schema_name
FROM md_connections,
md_catalogs ,
md_schemas ,
md_projects
WHERE md_schemas.catalog_id_fk = md_catalogs.id
AND md_catalogs.connection_id_fk = md_connections.id
AND md_connections.project_id_fk = md_projects.id

View Properties

Aliases "PROJECT_ID","PROJECT_NAME","CONNECTION_ID","HOST","PORT","USERNAME","CATALOG_ID","CATALOG_NAME","SCHEMA_ID","SCHEMA_NAME"
Create View With These Restriction Read Only

 

MIGRATION_WORKBENCH.MGV_ALL_SCHEMA_DETAILS

General Info

Caption MGV_ALL_SCHEMA_DETAILS

Body
AS
SELECT 'MD_SCHEMAS' objtype, s.name objname, s.id objid, 'MD_SCHEMAS' MainObjType,s.name MAINOBJNAME, s.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id connid,proj.project_name projectname,proj.id projectid,
NVL(conn.type,'CAPTURED') CapturedOrConverted,
CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name QualifiedName
FROM MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
WHERE s.catalog_id_fk = cat.id
AND cat.connection_id_fk = conn.id
AND conn.PROJECT_ID_FK = proj.id

View Properties

Aliases "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME"

 

MIGRATION_WORKBENCH.MGV_ALL_STORED_PROGRAMS

General Info

Caption MGV_ALL_STORED_PROGRAMS

Body
AS
SELECT md_projects.id project_id ,
md_projects.project_name project_name ,
md_connections.id connection_id ,
md_connections.host host ,
md_connections.port port ,
md_connections.username username ,
md_catalogs.id catalog_id ,
md_catalogs.catalog_name catalog_name ,
md_schemas.id schema_id ,
md_schemas.name schema_name ,
md_stored_programs.id stored_program_id ,
md_stored_programs.programtype programtype ,
md_stored_programs.name stored_program_name,
md_stored_programs.package_id_fk package_id_fk
FROM md_projects ,
md_connections,
md_catalogs ,
md_schemas ,
md_stored_programs
WHERE md_stored_programs.schema_id_fk = md_schemas.id
AND md_schemas.catalog_id_fk = md_catalogs.id
AND md_catalogs.connection_id_fk = md_connections.id
AND md_connections.project_id_fk = md_projects.id

View Properties

Aliases "PROJECT_ID","PROJECT_NAME","CONNECTION_ID","HOST","PORT","USERNAME","CATALOG_ID","CATALOG_NAME","SCHEMA_ID","SCHEMA_NAME","STORED_PROGRAM_ID","PROGRAMTYPE","STORED_PROGRAM_NAME","PACKAGE_ID_FK"

 

MIGRATION_WORKBENCH.MGV_ALL_TABLE_TRIGGERS

General Info

Caption MGV_ALL_TABLE_TRIGGERS

Body
AS
SELECT md_projects.id project_id ,
md_projects.project_name project_name,
md_connections.id connection_id ,
md_connections.host host ,
md_connections.port port ,
md_connections.username username ,
md_catalogs.id catalog_id ,
md_catalogs.catalog_name catalog_name,
md_catalogs.dummy_flag dummy_flag ,
md_schemas.id schema_id ,
md_schemas.name schema_name ,
md_tables.id table_id ,
md_tables.TABLE_NAME TABLE_NAME ,
md_triggers.id trigger_id ,
md_triggers.trigger_name trigger_name
FROM md_projects ,
md_connections,
md_catalogs ,
md_schemas ,
md_tables ,
md_triggers
WHERE md_triggers.table_or_view_id_fk = md_tables.id
AND md_tables.schema_id_fk = md_schemas.id
AND md_schemas.catalog_id_fk = md_catalogs.id
AND md_catalogs.connection_id_fk = md_connections.id
AND md_connections.project_id_fk = md_projects.id

View Properties

Aliases "PROJECT_ID","PROJECT_NAME","CONNECTION_ID","HOST","PORT","USERNAME","CATALOG_ID","CATALOG_NAME","DUMMY_FLAG","SCHEMA_ID","SCHEMA_NAME","TABLE_ID","TABLE_NAME","TRIGGER_ID","TRIGGER_NAME"

 

MIGRATION_WORKBENCH.MGV_ALL_TABLES

General Info

Caption MGV_ALL_TABLES

Body
AS
SELECT md_projects.id project_id ,
md_projects.project_name project_name,
md_connections.id connection_id ,
md_connections.host host ,
md_connections.port port ,
md_connections.username username ,
md_connections.dburl dburl ,
md_catalogs.id catalog_id ,
md_catalogs.catalog_name catalog_name,
md_schemas.id schema_id ,
md_schemas.name schema_name ,
md_tables.id table_id ,
md_tables.TABLE_NAME TABLE_NAME
FROM md_connections,
md_catalogs ,
md_schemas ,
md_tables ,
md_projects
WHERE md_tables.schema_id_fk = md_schemas.id
AND md_schemas.catalog_id_fk = md_catalogs.id
AND md_catalogs.connection_id_fk = md_connections.id
AND md_connections.project_id_fk = md_projects.id

View Properties

Aliases "PROJECT_ID","PROJECT_NAME","CONNECTION_ID","HOST","PORT","USERNAME","DBURL","CATALOG_ID","CATALOG_NAME","SCHEMA_ID","SCHEMA_NAME","TABLE_ID","TABLE_NAME"
Create View With These Restriction Read Only

 

MIGRATION_WORKBENCH.MGV_ALL_TABLES_DETAILS

General Info

Caption MGV_ALL_TABLES_DETAILS

Body
AS
SELECT 'MD_TABLES' objtype, t.table_name objname, t.id objid, 'MD_TABLES' MainObjType,t.table_name MAINOBJNAME, t.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id connid,proj.project_name projectname,proj.id projectid,
NVL(conn.type,'CAPTURED') CapturedOrConverted,
CASE WHEN conn.type IS NULL THEN ident.ldelimiter||cat.catalog_name||ident.rdelimiter||'.'||ident.ldelimiter || s.name||ident.rdelimiter||'.'||ident.ldelimiter|| t.table_name||ident.rdelimiter ELSE s.name||'.'||t.table_name END QualifiedName
FROM MD_TABLES t,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj,mgv_identifier_delimiter ident
WHERE t.schema_id_fk = s.id
AND s.catalog_id_fk = cat.id
AND cat.connection_id_fk = conn.id
AND conn.PROJECT_ID_FK = proj.id
AND ident.connection_id_fk = conn.id

View Properties

Aliases "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME"

 

MIGRATION_WORKBENCH.MGV_ALL_TRIGGER_DETAILS

General Info

Caption MGV_ALL_TRIGGER_DETAILS

Body
AS
SELECT 'MD_TRIGGERS' objtype,trig.trigger_name objname, trig.Id objid, 'MD_TABLES' MainObjType,t.table_name MAINOBJNAME,t.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id connid,proj.project_name projectname,proj.id projectid,
NVL(conn.type,'CAPTURED') CapturedOrConverted,
CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||trig.trigger_name QualifiedName
FROM MD_TRIGGERS trig, MD_TABLES t,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
WHERE trig.table_or_view_id_fk = t.id
AND t.schema_id_fk = s.id
AND s.catalog_id_fk = cat.id
AND cat.connection_id_fk = conn.id
AND conn.PROJECT_ID_FK = proj.id
UNION
SELECT 'MD_TRIGGERS' objtype,trig.trigger_name objname, trig.Id objid, 'MD_VIEWS' MainObjType,v.view_name MAINOBJNAME,v.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id connid,proj.project_name projectname,proj.id projectid,
NVL(conn.type,'CAPTURED') CapturedOrConverted,
CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||trig.trigger_name QualifiedName
FROM MD_TRIGGERS trig, MD_VIEWS v,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
WHERE trig.table_or_view_id_fk = v.id
AND v.schema_id_fk = s.id
AND s.catalog_id_fk = cat.id
AND cat.connection_id_fk = conn.id
AND conn.PROJECT_ID_FK = proj.id
ORDER BY objid

View Properties

Aliases "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME"

 

MIGRATION_WORKBENCH.MGV_ALL_VIEW_DETAILS

General Info

Caption MGV_ALL_VIEW_DETAILS

Body
AS
SELECT 'MD_VIEWS' objtype, v.view_name objname, v.Id objid, 'MD_VIEWS' MainObjType,v.view_name MAINOBJNAME,v.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id connid,proj.project_name projectname,proj.id projectid,
NVL(conn.type,'CAPTURED') CapturedOrConverted,
CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||v.view_name QualifiedName
FROM MD_VIEWS v,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
WHERE v.schema_id_fk = s.id
AND s.catalog_id_fk = cat.id
AND cat.connection_id_fk = conn.id
AND conn.PROJECT_ID_FK = proj.id

View Properties

Aliases "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME"

 

MIGRATION_WORKBENCH.MGV_ALL_VIEW_TRIGGERS

General Info

Caption MGV_ALL_VIEW_TRIGGERS

Body
AS
SELECT md_projects.id project_id ,
md_projects.project_name project_name,
md_connections.id connection_id ,
md_connections.host host ,
md_connections.port port ,
md_connections.username username ,
md_catalogs.id catalog_id ,
md_catalogs.catalog_name catalog_name,
md_catalogs.dummy_flag dummy_flag ,
md_schemas.id schema_id ,
md_schemas.name schema_name ,
md_views.id view_id ,
md_views.view_name view_name ,
md_triggers.id trigger_id ,
md_triggers.trigger_name trigger_name
FROM md_projects ,
md_connections,
md_catalogs ,
md_schemas ,
md_views ,
md_triggers
WHERE md_triggers.table_or_view_id_fk = md_views.id
AND md_views.schema_id_fk = md_schemas.id
AND md_schemas.catalog_id_fk = md_catalogs.id
AND md_catalogs.connection_id_fk = md_connections.id
AND md_connections.project_id_fk = md_projects.id

View Properties

Aliases "PROJECT_ID","PROJECT_NAME","CONNECTION_ID","HOST","PORT","USERNAME","CATALOG_ID","CATALOG_NAME","DUMMY_FLAG","SCHEMA_ID","SCHEMA_NAME","VIEW_ID","VIEW_NAME","TRIGGER_ID","TRIGGER_NAME"

 

MIGRATION_WORKBENCH.MGV_ALL_VIEWS

General Info

Caption MGV_ALL_VIEWS

Body
AS
SELECT md_projects.id project_id ,
md_projects.project_name project_name,
md_connections.id connection_id ,
md_connections.host host ,
md_connections.port port ,
username username ,
md_catalogs.id catalog_id ,
md_catalogs.catalog_name catalog_name,
md_catalogs.dummy_flag dummy_flag ,
md_schemas.id schema_id ,
md_schemas.name schema_name ,
md_views.id view_id ,
md_views.view_name view_name
FROM md_projects ,
md_connections,
md_catalogs ,
md_schemas ,
md_views
WHERE md_views.schema_id_fk = md_schemas.id
AND md_schemas.catalog_id_fk = md_catalogs.id
AND md_catalogs.connection_id_fk = md_connections.id
AND md_connections.project_id_fk = md_projects.id

View Properties

Aliases "PROJECT_ID","PROJECT_NAME","CONNECTION_ID","HOST","PORT","USERNAME","CATALOG_ID","CATALOG_NAME","DUMMY_FLAG","SCHEMA_ID","SCHEMA_NAME","VIEW_ID","VIEW_NAME"
Create View With These Restriction Read Only

 

MIGRATION_WORKBENCH.MGV_DERIVATIVES

General Info

Caption MGV_DERIVATIVES

Body
AS
SELECT "ID","SRC_ID","SRC_TYPE","DERIVED_ID","DERIVED_TYPE","DERIVED_CONNECTION_ID_FK","TRANSFORMED","ORIGINAL_IDENTIFIER","NEW_IDENTIFIER","DERIVED_OBJECT_NAMESPACE","DERIVATIVE_REASON","SECURITY_GROUP_ID","CREATED_ON","CREATED_BY","LAST_UPDATED_ON","LAST_UPDATED_BY" FROM MD_DERIVATIVES WHERE (Derivative_Reason <> 'SCRATCH' OR DERIVative_Reason IS NULL)

View Properties

Aliases "ID","SRC_ID","SRC_TYPE","DERIVED_ID","DERIVED_TYPE","DERIVED_CONNECTION_ID_FK","TRANSFORMED","ORIGINAL_IDENTIFIER","NEW_IDENTIFIER","DERIVED_OBJECT_NAMESPACE","DERIVATIVE_REASON","SECURITY_GROUP_ID","CREATED_ON","CREATED_BY","LAST_UPDATED_ON","LAST_UPDATED_BY"

 

MIGRATION_WORKBENCH.MGV_DERIVED_DETAILS

General Info

Caption MGV_DERIVED_DETAILS

Body
AS
select d1.catalogid capcatalogid, d1.catalogname capcatalogname, d1.connid capconnid,
d1.connname capconnname, d1.mainobjid capmainobjid, d1.mainobjname capmainobjname, d1.mainobjtype capmainobjtype , d1.objid capobjid,
d1.objname capobjname, d1.objtype capobjtype, d1.projectid capprojectid, d1.projectname capprojectname, d1.qualifiedname capqualifiedname,
d1.schemaid capschemaid, d1.schemaname capschemaname,
d2.catalogid concatalogid, d2.catalogname concatalogname, d2.connid conconnid,
d2.connname conconnname, d2.mainobjid conmainobjid, d2.mainobjname conmainobjname, d2.mainobjtype conmainobjtype , d2.objid conobjid,
d2.objname conobjname, d2.objtype conobjtype, d2.projectid conprojectid, d2.projectname conprojectname, d2.qualifiedname conqualifiedname,
d2.schemaid conschemaid, d2.schemaname conschemaname
FROM mgv_all_details d1 LEFT OUTER JOIN md_derivatives der
ON der.src_id = d1.objid
AND der.derivative_reason IS NULL LEFT OUTER JOIN mgv_all_details d2
ON der.derived_id = d2.objid
WHERE d1.capturedorconverted = 'CAPTURED'

View Properties

Aliases "CAPCATALOGID","CAPCATALOGNAME","CAPCONNID","CAPCONNNAME","CAPMAINOBJID","CAPMAINOBJNAME","CAPMAINOBJTYPE","CAPOBJID","CAPOBJNAME","CAPOBJTYPE","CAPPROJECTID","CAPPROJECTNAME","CAPQUALIFIEDNAME","CAPSCHEMAID","CAPSCHEMANAME","CONCATALOGID","CONCATALOGNAME","CONCONNID","CONCONNNAME","CONMAINOBJID","CONMAINOBJNAME","CONMAINOBJTYPE","CONOBJID","CONOBJNAME","CONOBJTYPE","CONPROJECTID","CONPROJECTNAME","CONQUALIFIEDNAME","CONSCHEMAID","CONSCHEMANAME"

 

MIGRATION_WORKBENCH.MGV_IDENTIFIER_DELIMITER

General Info

Caption MGV_IDENTIFIER_DELIMITER

Body
AS
SELECT CONNECTION_ID_FK,VALUE, CASE WHEN VALUE LIKE '%Sybase%' THEN '['
WHEN VALUE LIKE '%SQLServer%' THEN '['
WHEN VALUE LIKE '%MSAccess%' THEN '['
WHEN VALUE LIKE '%MySQL%' THEN'`'
WHEN VALUE LIKE '%DB2%' THEN '"'
WHEN VALUE LIKE '%Teradata%' THEN '"'
ELSE NULL END LDELIMITER,
CASE WHEN VALUE LIKE '%Sybase%' THEN ']'
WHEN VALUE LIKE '%SQLServer%' THEN ']'
WHEN VALUE LIKE '%MSAccess%' THEN ']'
WHEN VALUE LIKE '%MySQL%' THEN'`'
WHEN VALUE LIKE '%DB2%' THEN '"'
WHEN VALUE LIKE '%Teradata%' THEN '"'
ELSE NULL END RDELIMITER
FROM MD_ADDITIONAL_PROPERTIES WHERE LOWER(PROP_KEY) = 'plugin_id'

View Properties

Aliases "CONNECTION_ID_FK","VALUE","LDELIMITER","RDELIMITER"

 

MIGRATION_WORKBENCH.MGV_SCRATCH_DERIVATIVES

General Info

Caption MGV_SCRATCH_DERIVATIVES

Body
AS
SELECT "ID","SRC_ID","SRC_TYPE","DERIVED_ID","DERIVED_TYPE","DERIVED_CONNECTION_ID_FK","TRANSFORMED","ORIGINAL_IDENTIFIER","NEW_IDENTIFIER","DERIVED_OBJECT_NAMESPACE","DERIVATIVE_REASON","SECURITY_GROUP_ID","CREATED_ON","CREATED_BY","LAST_UPDATED_ON","LAST_UPDATED_BY" FROM MD_DERIVATIVES WHERE Derivative_Reason = 'SCRATCH'

View Properties

Aliases "ID","SRC_ID","SRC_TYPE","DERIVED_ID","DERIVED_TYPE","DERIVED_CONNECTION_ID_FK","TRANSFORMED","ORIGINAL_IDENTIFIER","NEW_IDENTIFIER","DERIVED_OBJECT_NAMESPACE","DERIVATIVE_REASON","SECURITY_GROUP_ID","CREATED_ON","CREATED_BY","LAST_UPDATED_ON","LAST_UPDATED_BY"