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
102
views
asked 2 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
56
views
asked 5 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
128
views
asked 6 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
158
views
asked 6 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
277
views
asked 7 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
238
views
asked 8 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
100
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
253
views
asked a year 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
65
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
563
views
asked 2 years agolg...
Can I generate a report to assess a migration to Babelfish?
Accepted AnswerBabelfish
1
answers
0
votes
351
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
316
views
asked 2 years agolg...