Albatross works in combination with Babelfish - an open source PostgreSQL extension from AWS that allows PostgreSQL to understand MSSQL queries.
Albatross helps you migrate your schema from SQL Server to PostgreSQL.
The tools runs an initial data copy then catches PostgreSQL up to the source SQL Server.
Once PostgreSQL is 100% caught up, it starts sending all queries to both databases.
Albatross logs queries along with their results to a CSV file for comparison.
Accelerate your PostgreSQL migration with these key features
Albatross catches up your Postgres database to your source SQL Server database without having to do any error prone manual transfers.
Once Postgres has caught up to SQL server, the tool can cut over from SQL Server to Postgres with zero downtime.
Albatross can detect and log any differences in query results between SQL Server and Postgres.
Bulk discounts available
Get help with the migration process
Benefit from our experience converting MSSQL schemas to work with Babelfish.
Get help during the final cut over process from MSSQL to PostgreSQL.
Feel free to reach out with any questions or comments