Data migration, AWS

schema conversion :

we can use this on google :

aws sct donwload

aws rds sql server

-------------

https://www.youtube.com/watch?v=2NnS55pto4I&t=1260s

Creating Read Replicas in RDS SQL Server

ada master dan replica nya

- Multi-AZ :

  tersedia untk standart dan enterprise for  new  versi

 newer versions the the enterprise editions of 2016 and 2017 (Always On)

but older versions and all of the standard editions right um old standard and

2014 and 2012 of enterprise rely on database (mirroring)

and you can tell um in the parenthesis it tells you the internal mechanism that is relying on

(dibawah versi ini tidak ada replica nya)

if sql server 2016 --> 13.005216 0v1

dibawah versi itu tidak ada replikanya 

 < sql server 2017 14.00.3223.3.v1

tidak ada replikanya 

 > sql server 2017 14.00.3223.3.v1

ada replika nya

https://www.youtube.com/watch?v=2NnS55pto4I&t=1260s

contoh nya pakai yg x

sql server 2017 14.00.3281.6.v1

fungsi promote replica adalah merubah yang tadinya 

Role role nya master dan replica berubah menjadi instance  instanc3

yang tadi nya 

menjadi 

---------------------------

https://www.youtube.com/watch?v=S7Zxz8nBjQs

(tidak ada replicanya)

Step-by-Step Guide: Create/launch AWS RDS SQL 2022 + SSMS & DBeaver Connection Setup | 2025 Updated

------------------------------------------

https://www.youtube.com/watch?v=W9z3wEcFA08&list=PLRFRM3JNuCkuItDmEE9_9_Uqs-sRVCCk_&index=13

WS DMS Tutorial: Migrate SQL Server to Amazon RDS (Step-by-Step)

(on premise to rds aws sql server)

----------------------------------------------

simple (schema conversion) using AWS SCT :

Database migration - Free tool (schema conversion) using AWS SCT :

https://www.youtube.com/watch?v=3oG_xewMpOM

------------------------------

aws rds postgres

aws DMS Tutorial: Migrate SQL Server to Amazon RDS (Step-by-Step) :

https://www.youtube.com/watch?v=W9z3wEcFA08&list=PLRFRM3JNuCkuItDmEE9_9_Uqs-sRVCCk_&index=13

----------------------------------------

aws : Data migration from SQL server to Aurora postgreSQL

https://www.youtube.com/watch?v=xyr9DcZEdls&pp=ygUfc3FsIHNlcnZlciB0byBhdXJvcmEgcG9zdGdyZXNxbA%3D%3D

1. rds sql with mirror

2. rds postgres with mirror

Tweet