Hi Datta ,
You can extract the data using the SSM Tool right click on the DB and use the extract wizard once done you can use a open source tool like SQLline to change the code. and then create them in Postgres .
For data you can move it using the SQL tool itself or take a BCP Out and then insert using the psql -d option .
Hi Samed
I have all type of objects tables,views, functions, procs etc with Data in table SqlServer database, which I am looking for migrating it to Postgresql with OpenSource tools.
Thanks
Datta
Hi Datta,
What objects do you exactly need to migrate? Tables, views, functions, indexes, procedures etc. Depending on object types, I can recommend multiple options. Unfortunately, I don't know any good solution that can convert all T-SQL code to pl/pgsql.
Best regards.
Samed YILDIRIM
Dear Admins I am looking for a reliable open-source tool for migrating MSSQL server to Postgresql on prem cloud.
Can you please suggest a related open-source tool for migrating all objects and data?
Thanks
Datta
--
Regards,
Gurudutt Dhareshwar