× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ashwini.chavan reported 2017-01-12T12:19:14Z  · tomconrad last modified 2018-03-15T21:24:46Z

OpenAPI methods for 'Database Triggers' and 'Database Audit Specifications' objects in MS SQL Server.


PM
Dev
Jenny Nishimura
JennyNishimura
QA
Jenny Nishimura
JennyNishimura
Priority Low
Complexity Unknown
Component Open API - RDBMS
Version Future
Steps:
1. Execute the following script on MS SQL Server 2016 version.
USE [master]
GO
/* ------ <Database Trigger> ------ */

CREATE TRIGGER [fy_dbtrigger_1]
ON DATABASE
FOR DROP_TABLE
AS
PRINT 'Tables cannot be dropped'
GO

USE [master]
GO
CREATE DATABASE AUDIT SPECIFICATION [test]
   FOR SERVER AUDIT [Payrole_Security_Audit12]
   WITH (STATE = ON)
GO
2. Generate 'Schema Compare' aqua script template in ADS for MS SQL Server. Select same database on above script is executed.
3. Execute aqua script template.
 
Result: Template not able to extract objects defined as 'Database Trigger' & 'Database Audit Specifications' objects.
As for this two objects, OpenAPI methods is not supported in ADS.But we can able to extract above objects through 'Schema Compare Tool'.(See screenshot)
 
1 attachment

Issue #14921

New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017