Join WhatsApp: www.whatsapp.com/channel/0029Va8fH154IBhEu3t21y2o 👉Get CloudWays ➜ www.cloudways.com/en/?id=1365224 💥CloudWays COUPON CODE: CLOUDGURU25 ☝☝ USE THE EXCLUSIVE COUPON CODE ABOVE TO GET 25% OFF FOR 3 MONTHS💥 👉Get Digital Ocean ➜ digitalocean.pxf.io/ZQERvQ 💥Get $200 FREE Credits for signup. So, hurry up!💥 ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
What about migrating the entire database, including indexes, stored procedures, views, etc? Do you have a video showing how to migrate an entire SQL Server Data Tier over to AWS RDS?
Poor video. The title of this video is totally different from what was presented. The title alludes that the migration is done using AWS DMS, and the video used a very basic migration of the data, not the schema/all database.
Hello sir, thanks for the session, I am using postgres database in AWS, we need to do a vacuume to free some space in db..can you please let me know what parameters we have to set in parameters group
Refer these links: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_BestPractices.html docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Autovacuum.html
Its just a simple table and data movement, where we have used the AWS DMS utility. Its like you have two servers and we copied the table and data from one server to second by the MSSQL export utility only.
I don't know what i just saw, I thought DMS in AWS is separate utility or tool to migrate data from onpremise to AWS RDS or EC2 but here you used the native SQL Server export/import functionality to move data from one database to another. Not to mention that this is least preferred approach in my opinion because frst it doesn't move other objcts in DB like SPs, indexes, views etc., it is just for moving data and the export import utility may be is straightforward for a dummy table with no complexities but will start throwing errors with column datatypes, identity values etc.
The only challenge here is that I have attempted to replicate this hand-on lab without success. For example, can you shed more light on the type of ec2 instance you choose, did you allow vpc of ec2 instance to talk to rds?...list goes on. Your response will be appreciated.
@@CloudGurus Hello...and many thanks for your response. I have followed the step in the video, thus: a. I observed that in the ec2 instance that you provisioned, there was already that AdventureWorks database in the ec2 instance. I assume you restored database from third party, so I also restored a copy of AdventureWorks database in the ec2 instance that I provisioned. b. I attempted to connect the endpoints from the rds that I provisioned by following your example. I kept receiving error and could not connect. c. The assumption is here that may be I need to allow my the vpc that I provisioned to talk to ec2 (I am not sure) d. I will appreciate further clarification
Refer these links: aws.amazon.com/blogs/database/migrating-sql-server-databases-from-microsoft-azure-to-aws-in-near-real-time-with-cloudbasic/ bh3r1th.medium.com/migrate-azure-sql-single-database-to-aws-rds-for-sql-server-using-aws-dms-719cc62c34a3
@@CloudGurus Thank you, you are a life saver. Should I be using VPN to connect AWS to GCP for migrations like migrating vms and databases? I am sure I read somewhere that it is the secure way to do it. Any links regarding that? :)
Refer these links: aws.amazon.com/premiumsupport/knowledge-center/migrate-mysql-rds-dms/ docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html
This example does not use DMS. Instead it uses the SQL Server the SQL Server import/export wizard. Why include DMS in the title ?????!!!!! Having DMS in the title implies your are using DMS to replicate the source database to the target database !!!
Join WhatsApp: www.whatsapp.com/channel/0029Va8fH154IBhEu3t21y2o
👉Get CloudWays ➜ www.cloudways.com/en/?id=1365224
💥CloudWays COUPON CODE: CLOUDGURU25
☝☝ USE THE EXCLUSIVE COUPON CODE ABOVE TO GET 25% OFF FOR 3 MONTHS💥
👉Get Digital Ocean ➜ digitalocean.pxf.io/ZQERvQ
💥Get $200 FREE Credits for signup. So, hurry up!💥
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
What about migrating the entire database, including indexes, stored procedures, views, etc? Do you have a video showing how to migrate an entire SQL Server Data Tier over to AWS RDS?
Yes will be uploaded soon.
Pls share the link?
Saved My Day .. Thanks 🙏
Glad to hear that
Why you named video with AWS DMS? There is nothing about the service in this video.
Thanks for the feedback.
Misleading title. You never used AWS DMS service. Please changed the title
okay
Thank u Cloud Guru!
You're most welcome!
Nice
Thanks
Poor video. The title of this video is totally different from what was presented.
The title alludes that the migration is done using AWS DMS, and the video used a very basic migration of the data, not the schema/all database.
Sorry for the inconvenience. Please try other videos.
Hello sir, thanks for the session,
I am using postgres database in AWS, we need to do a vacuume to free some space in db..can you please let me know what parameters we have to set in parameters group
Refer these links: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_BestPractices.html
docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Autovacuum.html
Hi Sir - what was the role of AWS Database migration service in this - it seemed like it mostly used sql server native import export utiility ?
Its migration service utility.
Its just a simple table and data movement, where we have used the AWS DMS utility. Its like you have two servers and we copied the table and data from one server to second by the MSSQL export utility only.
Yes correct.
@@CloudGurus Could you please upload a detail video for AWS DMS functionality. How its work for Homo and Heterogeneous data migration. Thanks
Sure will make one on that topic. Thanks for the suggestion.
Great video!
Thanks!
Thank you good one
You're welcome
There was no AWS Database Migration Service (DMS) service shown in this video...
Thanks for the feedback.
you said in premis to RDS cloud.
but on premise you used EC2 inst. which is still on cloud.
so basically its AWS EC2 to AWS RDS
Yes correct.
exactly in all the tutorials most of they re showing the same thing this is not cloud migration where the instance is already on cloud
Hi, it’s a great video, any video for migration of on prem sql-server to Aurora MySQL or PostgreSQL ?
Thanks for the feedback.
Why are you stating DMS? All of these comments tell you to change your title. Not cool!😠
Okay will change it.
@@CloudGurus bro its been a year and you still not updated the title.
this is not AWS DMS
Yes correct
thanks, brother!
You're welcome!
I don't know what i just saw, I thought DMS in AWS is separate utility or tool to migrate data from onpremise to AWS RDS or EC2 but here you used the native SQL Server export/import functionality to move data from one database to another. Not to mention that this is least preferred approach in my opinion because frst it doesn't move other objcts in DB like SPs, indexes, views etc., it is just for moving data and the export import utility may be is straightforward for a dummy table with no complexities but will start throwing errors with column datatypes, identity values etc.
Yes correct.
The only challenge here is that I have attempted to replicate this hand-on lab without success. For example, can you shed more light on the type of ec2 instance you choose, did you allow vpc of ec2 instance to talk to rds?...list goes on. Your response will be appreciated.
Where are you stuck right now. Can you give us some hints or error codes you are getting?
@@CloudGurus Hello...and many thanks for your response.
I have followed the step in the video, thus:
a. I observed that in the ec2 instance that you provisioned, there was already that AdventureWorks database in the ec2 instance. I assume you restored database from third party, so I also restored a copy of AdventureWorks database in the ec2 instance that I provisioned.
b. I attempted to connect the endpoints from the rds that I provisioned by following your example. I kept receiving error and could not connect.
c. The assumption is here that may be I need to allow my the vpc that I provisioned to talk to ec2 (I am not sure)
d. I will appreciate further clarification
Yes you are right. VPC for rds and ec2 should be the same. Otherwise you will get these kinds of connectivity errors.
Thanku
Please make a vedio on migration using cliqr/ appzero.
Thanks for the feedback.
Please change the Video title. Where you have shown us DMS. You are using export/import and what is new in that, this is old process.
Can suggest us with the title?
where is the use of AWS DMs service here???heading is different ,inside content is different
Sorry for the inconvenience. Please try other videos.
Sir how can we Migrate Azure SQL database to AWS RDS?
Refer these links: aws.amazon.com/blogs/database/migrating-sql-server-databases-from-microsoft-azure-to-aws-in-near-real-time-with-cloudbasic/
bh3r1th.medium.com/migrate-azure-sql-single-database-to-aws-rds-for-sql-server-using-aws-dms-719cc62c34a3
How to migrate from gcp(cloud sql db) to aws(rds) db. I was unable to figure out the endpoint, port for the db at gcp.
Can you please help?
Happy to help!
Refer this link: www.developer.com/db/migrating-a-mysql-database-from-cloudsql-to-aws-rds.html
@@CloudGurus Thank you, you are a life saver.
Should I be using VPN to connect AWS to GCP for migrations like migrating vms and databases?
I am sure I read somewhere that it is the secure way to do it. Any links regarding that? :)
You are welcome.
Refer this link: cloud.google.com/database-migration/docs/mysql/configure-connectivity-vpns
Sir how to use dms service using migrate onprem to AwS rds mysql
Refer these links: aws.amazon.com/premiumsupport/knowledge-center/migrate-mysql-rds-dms/
docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html
@@CloudGurus thank you sir
You didn't even user DMS service here
Yes correct.
Please make one video .How to Search a Customer API then Modification in Customer API table. ITS urgent please Ping me.
Sure will make one that. Thanks for the feedback. Appreciate it.
This example does not use DMS. Instead it uses the SQL Server the SQL Server import/export wizard. Why include DMS in the title ?????!!!!! Having DMS in the title implies your are using DMS to replicate the source database to the target database !!!
Sorry for the inconvenience. Try other videos.
The topic is unrelated. otherwise, it is a great video.
Hey, thanks
this is not DMS , make credible video sir?
Sure. Thanks for the feedback.
think i wasted my time here.
Sorry for the inconvenience. Try other videos.