*** Advance your career or learn some new skills with one of these courses *** Azure SQL Database Administration (DP300): cutt.ly/azure-sql-dp300 SQL Server 2022 Essential Training: cutt.ly/March2023 Kick Start Your PostgreSQL DBA Training: cutt.ly/postgres AWS Oracle RDS Database Administration Essential Training: cutt.ly/Oracle_RDS Mastering SQL Server on AWS: cutt.ly/L6AC8fX
Error : [2023-11-08 19:03:22.203] Aborted the task because of a task failure or a concurrent RESTORE_DB request. [2023-11-08 19:03:22.457] Task has been aborted [2023-11-08 19:03:22.460] Access Denied
Hi there just a quick question, what if the version of my premise is newer than the RDS database? I tried your method but my lifecycle says error. Any idea? Ty
Thank you for the video. I have a doubt. I have RESTful APIs in angular-based web applications which get/post data to Microsoft SQL DB. After migrating to AWS RDS, do I need to make any changes in those APIs? or in the web application?
It will be added to the database via the backup and restore option group. Reboot the db if it doesn’t work initially. Or delete the option group and redo that step.
*** Advance your career or learn some new skills with one of these courses ***
Azure SQL Database Administration (DP300): cutt.ly/azure-sql-dp300
SQL Server 2022 Essential Training: cutt.ly/March2023
Kick Start Your PostgreSQL DBA Training: cutt.ly/postgres
AWS Oracle RDS Database Administration Essential Training: cutt.ly/Oracle_RDS
Mastering SQL Server on AWS: cutt.ly/L6AC8fX
Great video, works perfectly... thank you!
You're welcome!
Brilliant video. Illuminating. Thank you.
You're very welcome
Thank you for sharing this knowledge! Good stuff
I appreciate you feedback!
Hello - Thank you so much for the tutorial, can you please share how to upload the tables from database into RDS ??
Error : [2023-11-08 19:03:22.203] Aborted the task because of a task failure or a concurrent RESTORE_DB request. [2023-11-08 19:03:22.457] Task has been aborted [2023-11-08 19:03:22.460] Access Denied
Getting this error on the script.....Could not find stored procedure 'msdb.dbo.rds_restore_database
Remove and re-add the options group and reboot.
Hi there just a quick question, what if the version of my premise is newer than the RDS database? I tried your method but my lifecycle says error. Any idea? Ty
Try this approach: How To Restore SQL Database to a Lower Version
ruclips.net/video/Ovv4W38YDOI/видео.html
Thank you@@redincs
Thank you for the video. I have a doubt. I have RESTful APIs in angular-based web applications which get/post data to Microsoft SQL DB. After migrating to AWS RDS, do I need to make any changes in those APIs? or in the web application?
While I don’t know much about REST APIs,if it was previously using the SQL host name or IP, the you would need to have it updated.
How you are handing the Discrepancies found in DMA report as source is 2014 and Target is 2017
Can you give me an example? But I’d migrate without them and recompile what’s possible after.
Any Behaviour/Breaking changes in DMA report
Can you do one video of migrating SQL server DB from EC2 to RDS, please? Thank you
Let me know if this helps: ruclips.net/video/zzGQRcpa1I0/видео.html
@redincs I watched that video already. Does it mean the steps are the same? whether it is from EC2 or from on-prem to RDS
Correct@@naod1989
how to add store procedure in sql
Check my previous response to your comment.
@@redincs this is the only procedure i have: dbo.rds_help_revlogin
dbo.rds_hexadecimal
dbo.rds_startup_tasks
Have you added the backup and restore option group?
Msg 2812, Level 16, State 62, Line 11
Could not find stored procedure 'msdb.dbo.rds_restore_database'.
It will be added to the database via the backup and restore option group.
Reboot the db if it doesn’t work initially.
Or delete the option group and redo that step.
you didn't explain where did you get this code "exec msdb.dbo.rds_restore_database"
Here: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html