You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Databases enumeration in Object Explorer has stopped working with SSMS 19.2 and later. As a workaround for existing DB clusters the following views needs to be created on Postgres connection (default port 5432):
CREATE OR REPLACEVIEWsys.availability_replicas
ASSELECT
CAST(NULLassys.UNIQUEIDENTIFIER) AS replica_id
, CAST(NULLassys.UNIQUEIDENTIFIER) AS group_id
, CAST(0asINT) AS replica_metadata_id
, CAST(NULLassys.NVARCHAR(256)) AS replica_server_name
, CAST(NULLassys.VARBINARY(85)) AS owner_sid
, CAST(NULLassys.NVARCHAR(128)) AS endpoint_url
, CAST(0assys.TINYINT) AS availability_mode
, CAST(NULLassys.NVARCHAR(60)) AS availability_mode_desc
, CAST(0assys.TINYINT) AS failover_mode
, CAST(NULLassys.NVARCHAR(60)) AS failover_mode_desc
, CAST(0asINT) AS session_timeout
, CAST(0assys.TINYINT) AS primary_role_allow_connections
, CAST(NULLassys.NVARCHAR(60)) AS primary_role_allow_connections_desc
, CAST(0assys.TINYINT) AS secondary_role_allow_connections
, CAST(NULLassys.NVARCHAR(60)) AS secondary_role_allow_connections_desc
, CAST(NULLassys.DATETIME) AS create_date
, CAST(NULLassys.DATETIME) AS modify_date
, CAST(0asINT) AS backup_priority
, CAST(NULLassys.NVARCHAR(256)) AS read_only_routing_url
, CAST(NULLassys.NVARCHAR(256)) AS read_write_routing_url
, CAST(0assys.TINYINT) AS seeding_mode
, CAST(NULLassys.NVARCHAR(60)) AS seeding_mode_desc
WHERE FALSE;
GRANTSELECTONsys.availability_replicas TO PUBLIC;
CREATE OR REPLACEVIEWsys.availability_groups
ASSELECT
CAST(NULLassys.UNIQUEIDENTIFIER) AS group_id
, CAST(NULLassys.SYSNAME) AS name
, CAST(NULLassys.NVARCHAR(40)) AS resource_id
, CAST(NULLassys.NVARCHAR(40)) AS resource_group_id
, CAST(0asINT) AS failure_condition_level
, CAST(0asINT) AS health_check_timeout
, CAST(0assys.TINYINT) AS automated_backup_preference
, CAST(NULLassys.NVARCHAR(60)) AS automated_backup_preference_desc
, CAST(0asSMALLINT) AS version
, CAST(0assys.BIT) AS basic_features
, CAST(0assys.BIT) AS dtc_support
, CAST(0assys.BIT) AS db_failover
, CAST(0assys.BIT) AS is_distributed
, CAST(0assys.TINYINT) AS cluster_type
, CAST(NULLassys.NVARCHAR(60)) AS cluster_type_desc
, CAST(0asINT) AS required_synchronized_secondaries_to_commit
, CAST(0assys.BIGINT) AS sequence_number
, CAST(0assys.BIT) AS is_contained
WHERE FALSE;
GRANTSELECTONsys.availability_groups TO PUBLIC;
The text was updated successfully, but these errors were encountered:
Databases enumeration in Object Explorer has stopped working with SSMS 19.2 and later. As a workaround for existing DB clusters the following views needs to be created on Postgres connection (default port
5432
):The text was updated successfully, but these errors were encountered: