Thanks for this awesome video with a good explanation, however I have one question, why we have created Option Group, when we have used the procedure to restore DB from S3. I count not co-related the Option Group, could you please explain its purpose with restoration of DB.
If you attached the particular option to the DB instance then if Option group is active , you can begin backup the DB instance to the S3 and restore back , no Db instance restart is required. You can view my other video as well ruclips.net/video/ZNvLBU6pxpM/видео.html
Hello i was following your guide I clicked my database then modify, scrolled down to "Database Options" and when i click the dropdown, there are no other options except the default option group which is "default:sqlserver-ex-15-00".....can you please help? Thanks.
Hello Thanks a lot for the video. Just have a question. Is this process Network dependent? I set this up while I was at my work place and every time I try to connect from my home it never gets connected.
Most likely you may need to white list your IP address from home to allow access to your AWS resource. This is very common and I would argue bare minimum in terms of security to not allow access from any public address. Assuming you have a viable VPN with IP addresses white listed to your AWS VNet, then you should be able to ping your AWS workplace network.
ok, let me know which part you did not understand? 1. first you have to create db instance in AWS RDS DB instance 2. access the rds db instance from the local SQL sever management studio (you need to allow the access ) 3. then , from your local db instance ( which is your lets say on-premises db instance) , take back up of it , move the back up file to S3 bucket 4. in RDS db instance , make it restore capable using option group. 5. the RDS DB instance which you are accessing from SSMS , execute the stored procedure to restore the backed up db which is stored in s3 bucket. simple , is not it?
Thanks for the clear instructions. Very helpful!
glad it helped you !
Very helpful video, thank you!
Glad it was helpful!
Thanks for this awesome video with a good explanation, however I have one question, why we have created Option Group, when we have used the procedure to restore DB from S3. I count not co-related the Option Group, could you please explain its purpose with restoration of DB.
If you attached the particular option to the DB instance then if Option group is active , you can begin backup the DB instance to the S3 and restore back , no Db instance restart is required. You can view my other video as well
ruclips.net/video/ZNvLBU6pxpM/видео.html
Hello i was following your guide I clicked my database then modify, scrolled down to "Database Options" and when i click the dropdown, there are no other options except the default option group which is "default:sqlserver-ex-15-00".....can you please help? Thanks.
you need to create option group first as i instructed at around 11th minutes in the session
Thank you for your reply....i already created that by following your guide but it won't show up.@@RamdhanSharma-pf9mt
Hello
Thanks a lot for the video. Just have a question.
Is this process Network dependent?
I set this up while I was at my work place and every time I try to connect from my home it never gets connected.
no i believe , you can connect it from your personal network to AWS network
Most likely you may need to white list your IP address from home to allow access to your AWS resource. This is very common and I would argue bare minimum in terms of security to not allow access from any public address. Assuming you have a viable VPN with IP addresses white listed to your AWS VNet, then you should be able to ping your AWS workplace network.
please explain in details cant understand half of it..
ok, let me know which part you did not understand?
1. first you have to create db instance in AWS RDS DB instance
2. access the rds db instance from the local SQL sever management studio (you need to allow the access )
3. then , from your local db instance ( which is your lets say on-premises db instance) , take back up of it , move the back up file to S3 bucket
4. in RDS db instance , make it restore capable using option group.
5. the RDS DB instance which you are accessing from SSMS , execute the stored procedure to restore the backed up db which is stored in s3 bucket.
simple , is not it?
Sir how can we Migrate Azure SQL database to AWS RDS?
Never done this but I guess you can utilize AWS Data Migration Service to do this. you need to setup public access from AWS DMS to your Azure SQL DB.
@@datapundit Thank You
How can you learn these no of skills😇
I will be expert like you.. can you please guide or suggest the path you reached.. My Primary skill is Abinitio