Migration de sqlserver vers postgresql

Un bon guide à suivreHow to Convert SQL Server to PostgreSQL – Complete Migration Guide.PDF

https://dbconvert.com/blog/sql-server-to-postgresql-migration-guide/

[SQL SERVER] Practical guidance to make your tier-1 SQL Server roar - BRK3155

Yes we are in 2025 but this is sill under review ! 

PRACTICAL GUIDANCE

EDB feedback

Article intéressant sur le 0 downtime des cartes mastercard.

[Cloud IBM PSQL] Role creation with HVAULT (static dba)

script : prepare_dba_static_role.sh

 

[PSQL] Autovacuum PostgreSQL on AZURE

Comment configurer l'autovacuum de manière agressive afin qu'il soit plus performant sur postgresql flexible server dans Azure ?

[PSQL] Que contient les fichiers wal

Un bon tuto à faire !

What’s Inside a WAL File

[PSQL] 5 biggest tables

SELECT relname AS "relation", pg_size_pretty ( pg_total_relation_size (C .oid) ) AS "total_size" FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C .relnamespace) WHERE nspname NOT IN ( 'pg_catalog', 'information_schema' ) AND C .relkind <> 'i' AND nspname !~ '^pg_toast' ORDER BY pg_total_relation_size (C .oid) DESC LIMIT 5;

[ISSUE]PostgreSQL: Permission denied for large object

PostgreSQL: Permission denied for large object

[POSTGRES] Easy to migrate

Little bash script

Oracle backup batch file

Oracle backup batch file - Stack Overflow

need to split in two files: a batch file and RMAN script

Batch file: backup.bat

@echo off
echo Automatic Backup Oracle
pushd .
SET ORACLE_HOME=C:apporacleproduct12.2.0dbhome_1
SET ORACLE_SID=ORCL
echo ----------------------------------------------------
echo ORACLE_HOME : %ORACLE_HOME%
echo ORACLE_SID  : %ORACLE_SID%
echo ----------------------------------------------------
RMAN TARGET / @file.rman log=backup.log

Script RMAN called file.rman or another name

run {
backup database;
backup archivelog all delete input;
} 

This part is setup:

CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'c:backup%F';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'c:backup%d_%T_%u';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'c:backupSNCFORCL.ORA';

Can be removed from the script and run once for each bank. Once configured, the settings are permanent.

script need two files: backup.bat and file.rman