All Questions
Tagged with sql-server postgresql
951
questions
0
votes
0
answers
49
views
504 Gateway Timeout Error when Configuring Supabase Wrapper for SQL Server
I'm trying to configure a Supabase wrapper to connect to my SQL Server database. After filling out the configuration form in Supabase and adding the columns for the table, I receive a 504 Gateway ...
0
votes
0
answers
51
views
How do upload images to Jfrog with layers larger than 2GB when using an external database
We are currently encountering issues with our JFrog Installation. Our JFrog is running in Kubernetes, and initially, we had it running with regular PVCs and no problems. However, when we attempted to ...
0
votes
0
answers
45
views
Issue when migrating data from SQL Server to Postgres
I want to migrate data from SQL Server to Postgres. I use the PGLOADER tool.
load database
from mssql://sa:password@ms-server:1433/Identity
into postgresql://postgres:[email protected]:...
- 567
-3
votes
0
answers
58
views
How to transfer data from SQL Server 2000 to Postgresql
Please provide ideas on how to transfer data from SQL Server 2000 to Postgresql 15. I tried with an odbc connection, but it was not possible since on the Microsoft page there is no obdc for SQL Server ...
- 11
1
vote
0
answers
61
views
Problem upgrading .NET 3.1 to .NET 8, context.GetService cannot be used inside OnModelCreating
I am trying to transfer my whole project from .NET 3.1 to .NET 8.
I have resolved some smaller issues but have encountered this major issue which stops me from completing the transition.
What I have ...
- 41
0
votes
0
answers
33
views
How to set "native" db types when passing parameters, e.g., NpgsqlDbType / SqlDbType / or just parameter.TypeName / etc.)
I'm trying to figure out a way to set "native" db type, such as:
PostgreSQL: NpgsqlDbType
SQL Server: SqlDbType
SQLite: SqliteType
and others
when using DynamicParameters.
without writing ...
- 8,785
0
votes
1
answer
112
views
Python locust tasks are blocked when used with pyodbc
I am encountering an issue with Python Locust where tasks seem to be blocked when using the pyodbc library, but interestingly, the same tasks work fine when using pyodbc within a ThreadPool. I've ...
1
vote
1
answer
56
views
Transfer data from Postgre to Microsoft Sql Server
I want to transfer data from Postgre with context _rentContext to Microsoft Sql Server with context _rentContextSql.
In my program first I check if that record exists in _rentContextSql it doesn't add ...
0
votes
1
answer
134
views
pass parameters to database connection in pentaho using jenkins freestyle job
I'm a beginner in pentaho, I'm trying to pass parameters from jenkins for the transformation I'm working on,
Transformation details: Joining two tables from mssql and writing it in psql.
What I tried ...
- 23
0
votes
0
answers
475
views
Decompress equivalent in postgresql for compressed column
I have SQL Server data where compressed data is stored like this:
After migrating to Postgresql, data is as above. How to get decompressed data in Postgresql?
Tried with decode function for ...
- 497
-1
votes
1
answer
133
views
"UTC" is recognized as "Z" to be compatible with the legacy style
I transfer data from SQL Server to PostgreSQL using Embulk. Postgresql version 15.4
Below are the drivers I used and the input and output gems installed in the embulk gem list.
Java version: 1.8
SQL : ...
2
votes
3
answers
421
views
Understanding multiple GROUPING SETS
I am clear on how GROUPING SETS (and ROLLUP and CUBE) work for a single expression. However, I've never entirely understood how it works when multiple GROUPING SETS are combined. Here is an example ...
- 109k
0
votes
1
answer
65
views
getUpdateCount returns total number of rows updates for Oracle, but returns -1 in PostgreSQL and SQL Server, and latest count in H2
I am trying batch update and then get total number of rows affected. For Oracle I get correct output by using getUpdateCount, but this API fails for PostgreSQL, SQL Server and H2. For these databases ...
- 105
0
votes
0
answers
108
views
Exporting data from SQL server to PostgreSQL limited 100 records
I have a database in SQL Server, but now I must transfer to PostgreSQL.
I'm trying to the way:
Right-click on the database
Task/ExportData
Choose the database input enter image description here
...
- 11
0
votes
0
answers
107
views
Migrating Appian's internal DB from PostgreSQL to SQL Server?
For all non-Appian SQL specialists: Appian is a low-code platform which needs two central datastores. The database appian_internal contains details about Appian's internal objects such as general ...
- 5,792