I have just completed testing a TALEND ETL that migrates databases from MS SQL to POSTGRESQL.
Tested with a number of database such as WorldwideImporters and AdventureWorks.
The ETL will migrate tables, views, data, indexes, constraints, sequences, generates columns.
The process will convert the MS SQL data types to comparable Postgresql data types.
All that is required is the target database to be set up, and then update a configuration file to provide the access connections to the source and target databases.
All schemas in the source database will be migrated, or you can selected them one at a time.
Looking to work with you to test it further with your database if you have the requirement to move to Postgresql.
Email me at rhard2651@gmail.com if you are interested.
