Feature Request for Sybase

Hi

Is there any plans to have a feature where on 1 click DataGrip will extract all the definition of an object. For example for a table it would extract the DDL including permissions and indexes. For a proc it would extract definition and permissions

It would be a very nice feature to have. Rather than having to extract stuff individually

5 comments
Comment actions Permalink

Hello,
What Sysbase database version and database driver do you use (note that there could be issues with odbc drivers: https://youtrack.jetbrains.com/issue/DBE-844 )?

With JDBC driver copying DDL should work: https://www.jetbrains.com/datagrip/help/working-with-the-database-tool-window.html#d76185e654 . If there is a problem, would be greate if you could specify the details (db, driver version, what exactly is not detected) in YouTrack issue https://youtrack.jetbrains.com/issues/DBE . Thanks.

0
Comment actions Permalink
  
Database Version : Adaptive Server Enterprise/15.7/EBF 23821
 
Sybase Driver    : jtds-1.2.5 ( Downloaded from Jetbrains)
  
What i am requesting is the following
  
1) Current Version of DBE extracts DDL but does not extract permissions/grants
  
2) Stored Proc extraction does not work..
   
-- Failed to load definition
-- You must have the following role(s) to execute this command/procedure: 'sa_role'. Please contact a user with the appropriate role for help.
--
-- auto-generated definition
CREATE FUNCTION cleanDataExplorerByBatchDate
()
0
Comment actions Permalink

For point 1, can you please post example of some DDL (the expected and the actual result)? Thank you.

0
Comment actions Permalink

USE efs_reporting
go
CREATE TABLE dbo.mx_unsolicited_journal
(
    mxSequenceNumber    numeric(10,0) IDENTITY,
    messageType         varchar(16)   NOT NULL,
    serviceProviderName varchar(128)  NOT NULL,
    message             varchar(512)  NOT NULL,
    systemTime          datetime      NOT NULL,
    CONSTRAINT mx_unsolic_mxSequ_16546613382
    PRIMARY KEY CLUSTERED (mxSequenceNumber)
)
LOCK DATAROWS
WITH EXP_ROW_SIZE=1
go
IF OBJECT_ID('dbo.mx_unsolicited_journal') IS NOT NULL
    PRINT '<<< CREATED TABLE dbo.mx_unsolicited_journal >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE dbo.mx_unsolicited_journal >>>'
go
CREATE NONCLUSTERED INDEX idx_systemTime
    ON dbo.mx_unsolicited_journal(systemTime)
LOCAL INDEX idx_systemTime_1654661338
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.mx_unsolicited_journal') AND name='idx_systemTime')
    PRINT '<<< CREATED INDEX dbo.mx_unsolicited_journal.idx_systemTime >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX dbo.mx_unsolicited_journal.idx_systemTime >>>'
go

GRANT REFERENCES ON dbo.mx_unsolicited_journal TO edp
go
GRANT SELECT ON dbo.mx_unsolicited_journal TO edp
go
GRANT INSERT ON dbo.mx_unsolicited_journal TO edp
go
GRANT DELETE ON dbo.mx_unsolicited_journal TO edp
go
GRANT UPDATE ON dbo.mx_unsolicited_journal TO edp
go


0

Please sign in to leave a comment.