Questions tagged with Babelfish
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
In SQL Server, you can run
```select * from information_schema.table_constraints where constraint_type = 'FOREIGN KEY'```
However, in Babelfish, the constraint name listed in the output is actually...
1
answers
0
votes
134
views
asked 3 months agolg...
We faced the below error when run query with offset ... rows.. fetch next...
```
Msg 33557097, Level 16, State 1, Line 57
syntax error at or near "ROWS"
Total execution time: 00:02:42.886
```
This...
0
answers
0
votes
86
views
asked 6 months agolg...
Babelfish upgrade errors from Aurora 13.8 with Babelfish 1.4.0 to Aurora 14.6 with Babelfish 2.3.0lg...
Customer is receiving these errors while attempting to upgrade their database - this is an in-place upgrade where everything is currently working under version Aurora 13.8 with Babelfish 1.4.0
**Some...
0
answers
0
votes
138
views
asked 7 months agolg...
MSSQL RDS is migrated to Postgres RDS Aurora using Babelfish.
This migrated db works fine with direct endpoint of RDs Aurora Instance.
But fails to recognize Old MSSQL queries , Stored procedures...
0
answers
0
votes
187
views
asked 8 months agolg...
Hi.
TL;DR: I'm trying to understand how to change the parameter `babelfishpg_tsql.escape_hatch_rowversion` values to `ignore` for all SQL sessions ran against the TDS port.
----
I'm using Aurora...
1
answers
0
votes
315
views
asked 9 months agolg...
Hi.
Given an application that used to run multiple DB scripts against SQL Server in a single transaction, how can I implement the same when moving the Aurora Postgres?
The challenge is as...
2
answers
0
votes
267
views
asked 9 months agolg...
Given that Babelfish creates the babelfish_db and the sql server databases are represented as schemas such as dbname_schema when in multi-db mode.
What is the recommendation to perform backup and...
0
answers
0
votes
118
views
asked a year agolg...
I am migrating from MS Sqlserver to Postgrasql with Babelfish. I cannot get the update commands in my stored procedures to work. I've used Compass and it passes. I have built the following simple...
1
answers
0
votes
279
views
asked 2 years agolg...
I have 2 questions
* Does Babelfish for aurora support TLS 1.2 encryption in flight?
* what port does it use for encryption if so 1433? is that port changeable?
0
answers
0
votes
73
views
asked 2 years agolg...
Both SCT and Compass can report assessments for SQL Server migrations to Babelfish. Which should I use?
Accepted AnswerBabelfish
2
answers
1
votes
601
views
asked 2 years agolg...
Can I generate a report to assess a migration to Babelfish?
Accepted AnswerBabelfish
1
answers
0
votes
380
views
asked 2 years agolg...
How can I get the equivalent to SET SHOWPLAN_ALL or similar SHOWPLAN options / show query execution plans in Babelfish? How can I optimize queries?
Accepted AnswerBabelfish
1
answers
0
votes
349
views
asked 2 years agolg...