Stack Overflow
Stack Overflow

Questions tagged [babelfish]

Babelfish for PostgreSQL by Amazon is a PostgreSQL server modification that enables PostgreSQL to speak the TDS protocol; see https://babelfishpg.org/

22 questions
0
votes
0 answers

AWS Babelfish co-releated sub query provides in correct results

We are migrating a sql server Database to AWS Aurora Postgres with Babelfish enabled. I connected the Babelfish DB from SSMS through 1433 port. While I ran Babelfish compass report and fixed the un supported functionality. There are few issues which…
Manjunath
  • 323
  • 1
  • 3
  • 15
0
votes
2 answers

"User_name" is not a babelfish user

I have created role under postgresql using PgAdmin. CREATE ROLE user_name LOGIN PASSWORD 'xyz'; I'm able to login to server using pgAdmin using above credentials. But when I try to connect from MSSQL Server (Babelfish) getting an following…
MAK
  • 6,824
  • 25
  • 74
  • 131
0
votes
1 answer

Accessing Tables outside of Babelfish_DB

Can I access data from tables that are not part of the Babelfish_DB? I have tried USE AnotherDatabase SELECT * FROM sys.tables -- Returns all DB's defined in the Babelfish_DB scope? SELECT * FROM TableInBabelFishDBScope -- works fine SELECT * FROM…
Ross Bush
  • 14,648
  • 2
  • 32
  • 55
0
votes
0 answers

User without create table permission when using babelfish as a target endpoint in AWS DMS

I'm trying to migrate some data from SQL Server to AWS Aurora (Postgres) by using the babelfish capability. It was recently added as a target in the AWS DMS service. However, the connection test fails with the following message: Test Endpoint…
João Neto
  • 51
  • 1
  • 3
0
votes
1 answer

Can I migrate multiple SQL DBs into a single Babelfish instance and keep them segregated for different users?

I am migrating multiple SQL DBs (say A and B) to a single Babelfish instance. I have SQL instance A with tables x, y and z and instance B with tables x, y and z. I want Babelfish to have some way to have them coexist as A.x, A.y, A.z, B.x, B.y and…
winmax
  • 3
  • 1
0
votes
2 answers

Stored procedures with unqualified table names not working with Babelfish

I have created a Babelfish-enabled Postgres database in RDS. I connected with SSMS and created a Database named 'demo'. Within 'demo' I created a Schema named 'biz'. I created my tables and stored procedures in the 'biz' schema. The stored…
Brad Thomas
  • 1
  • 1
0
votes
1 answer

Querying Postgres through Babelfish

I am connected over TDS (1433) to a Postgres/Aurora (babelfish-enabled) database. I can run the following three queries from my application and I receive confusing responses: SELECT current_database() SELECT * FROM information_schema.tables WHERE…
Nick
  • 466
  • 1
  • 6
  • 12
1
2