AWS Database Migration Service

Re:AWS Database Migration Service by jrgoj on Tuesday March 15, 2016 @07:53PM (#11293953)

What are my chances of a relatively successful SQL Server migration with several hundred tables and complex views to PostgreSQL using their migration tool?

[ Parent | on HN ]

Re:AWS Database Migration Service by manigandham on Tuesday March 15, 2016 @08:35PM (#11294133)

I tried this, SQL Server isnt supported yet... its just not even in the dropdown options. However it is listed in the marketing and product overview text so it seems like it's coming.

EDIT: looks like it's there now. will try it out tonight then.

[ Parent | on HN ]

Re:AWS Database Migration Service by jrgoj on Tuesday March 15, 2016 @09:02PM (#11294235)

Great! Let me know how it goes. It will be a couple of days before I can try it. Hopefully I can migrate just the schema and cherry pick some relatively static tables. We'll see.

[ Parent | on HN ]

Re:AWS Database Migration Service by ams6110 on Tuesday March 15, 2016 @09:18PM (#11294319)

Postgres and SQL Server have different concurrency semantics, unlikely that you won't have subtle bugs unless your updates are very straightforward.

[ Parent | on HN ]