question

sljesra avatar image
0 Votes"
sljesra asked sljesra commented

Pivotal Greenplum to MS SQL 2019 Data Migration

Hello,

Please share any documentation/process on data migration from Pivotal Greenplum database to MS SQL 2019 server.

I've checked below link. Would be helpful with more information with latest version if any.

https://social.msdn.microsoft.com/Forums/en-US/0d323791-e45a-458d-9b1c-8a14dfe4dc66/greenplum-to-sql-server-2012-data-migration?forum=sqlservermigration


Regards,
Rajes

sql-server-migration
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sljesra,

Just checking in to see if the answer helped.
If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.
And If you have further questions or issues please let us know.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered sljesra commented

Hi @sljesra,

Please try the suggestions from the thread that you mentioned. The methods also supported in SQL server 2019.

Using SSIS import Greenplum Data into SQL Server, please refer to the blog Import Greenplum Data into SQL Server using SSIS to get more detail steps.

Or you can try this third tool Convert Greenplum to SQL Server.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Cathyji-msft ,

Thank you for the response.

My query is answered. Currently only SSIS supports to migrate data from Greenplum/Postgres to MS SQL.

0 Votes 0 ·