MS SQL migration to POSTGRESQL

rhefinity — Sat, 16 Nov 2024 00:09:44 GMT

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.

Re: MS SQL migration to POSTGRESQL

Anonymous — Tue, 18 May 2021 07:56:19 GMT

Hello,

It looks like an interesting piece of work!

Best regards

Sabrina

topic Re: MS SQL migration to POSTGRESQL in Talend Studio

MS SQL migration to POSTGRESQL

Re: MS SQL migration to POSTGRESQL