POSTGRES & MSSQL:
-> When taking a backup using the command backUpData.bat/backUpData.sh the backup will be created in the EZIP format. This is the native model of PGSQL / SQL.
-> When taking a backup using the command backUpDataOld.bat/backUpDataOld.sh the backup will be created in the .DATA format
-> If it is taken directly in the MSSQL server then the backup will be in BAK format.
Restore:
Postgres:
-> You can restore the Postgres EZIP backup directly using the command restoredata.bat/restoredata.sh into any Postgres installation. (Windows - linux)
-> You can also restore the Postgres DATA backup directly using the command restoredata.bat/restoredata.sh into any installation. (Windows - linux)
-> You cannot restore the BAK format MSSQL backup into postgres server
MSSQL:
-> If it is a MSSQL EZIP backup then it can only be restored into the same MSSQL server and cannot be restored into a different MSSQL server.
-> If it is a MSSQL DATA backup(.data format) then it can be restored into different MSSQL.
-> It is a MSSQL BAK backup then it can be restored into any MSSQL server
In Schedule backup (EZIP format), Cross OS or Cross DB wont restore.
ie. We cannot take a backup from PGSQL and cannot restore in MSSQL. (viceversa)
Also we cannot take a backup from Windows - PGSQL installation and cannot restore in Linux PGSQL installation(viceversa) As its native dump methodology , it wont.
Manual EZIP format :
We can take ezip format by executing backupDB.bat - We can take back up from Windows PGSQL and restore in Linux PGSQL. (vice versa). - Its supported