search

babelfish-for-postgresql / babelfish_extensions

Babelfish for PostgreSQL provides the capability for PostgreSQL to work with applications written for Microsoft SQL Server. Babelfish understands the SQL Server wire-protocol and T-SQL, the Microsoft SQL Server query and procedural language, so you don’t have to switch database drivers or rewrite all of your application queries.
https://babelfishpg.org/
Apache License 2.0
265 stars 87 forks source link

[Bug]: Cannot view AWS RDS Aurora tables in SSMS (SQL Server Management Studio) #2668

Closed umayyanathan closed 2 weeks ago

umayyanathan commented 2 weeks ago

What happened?

I am able to connect to the AWS RDS Aurora instance from SSMS by choosing the database in the Object Explorer --> Connect --> Connection Properties --> Choose 'Test' database.

However, I cannot view the Database or Tables in the Object Explorer in SSMS. See screenshot attached. To the contrary and interestingly, I am able to get results successfully when I ran a SELECT statement in the Query window of SSMS.

Please advise what is missing to view the database objects in the object explorer.

Uma

Version

BABEL_4_X_DEV (Default)

Extension

babelfishpg_tsql (Default)

Which flavor of Linux are you using when you see the bug?

No response

Relevant log output

No response

Code of Conduct

umayyanathan commented 2 weeks ago

SQL Server Object Explorer

umayyanathan commented 2 weeks ago

No Database or Tables

umayyanathan commented 2 weeks ago

For reference, I have attached screenshots.

suprio-amzn commented 2 weeks ago

@umayyanathan: Please provide version info for SSMS as well as Babelfish.

umayyanathan commented 2 weeks ago

AWS RDS Aurora (PostGres 15.3 with BabelFish) has the BabelFish version 3.3.0 SSMS version is 19.3.4.0

umayyanathan commented 2 weeks ago

babelfishVersion

suprio-amzn commented 2 weeks ago

@umayyanathan: If you are using Babelfish for Aurora PostgreSQL, please upgrade to the latest version either to Babelfish for Aurora 3.5 or Babelfish for Aurora 4.1 where a similar issue has been fixed with SSMS version 19.2, I suspect the same exists with SSMS 19.3 also.

umayyanathan commented 2 weeks ago

Thank you @suprio-amzn. I will try and keep you posted.

umayyanathan commented 2 weeks ago

Sorry, same issue...

umayyanathan commented 2 weeks ago

ssms

umayyanathan commented 2 weeks ago

I deleted the RDS Aurora 3.5 babelfish test instance completely and re-created with the latest version (for PostGres 16.2). Now the tables are showing up in SSMS.

Thank you very much for your reference and help @suprio-amzn.

shalinilohia50 commented 1 week ago

I have also tried with SSMS version 19.3.4.0 (latest). There is an issue with the Babelfish version 3.4 where I couldn't view the Database in the Object Explorer in SSMS. As @suprio-amzn mentioned, it is resolved in Babelfish version 3.5.