*** 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
@luis-ibarra-consiglieri7 ай бұрын
Great video, works perfectly... thank you!
@redincs7 ай бұрын
You're welcome!
@ChanceMinus Жыл бұрын
Brilliant video. Illuminating. Thank you.
@redincs Жыл бұрын
You're very welcome
@vaibhavverma13409 ай бұрын
Hello - Thank you so much for the tutorial, can you please share how to upload the tables from database into RDS ??
@bobsukki2 жыл бұрын
Thank you for sharing this knowledge! Good stuff
@redincs2 жыл бұрын
I appreciate you feedback!
@RealWellnessWarrior9 ай бұрын
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
@naod198910 ай бұрын
Can you do one video of migrating SQL server DB from EC2 to RDS, please? Thank you
@redincs10 ай бұрын
Let me know if this helps: kzbin.info/www/bejne/sKuqgoWZpcZkf5I
@naod198910 ай бұрын
@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
@emarversity10 ай бұрын
Correct@@naod1989
@stouttaaddis98911 ай бұрын
Getting this error on the script.....Could not find stored procedure 'msdb.dbo.rds_restore_database
@redincs11 ай бұрын
Remove and re-add the options group and reboot.
@nitinpatil475211 ай бұрын
How you are handing the Discrepancies found in DMA report as source is 2014 and Target is 2017
@redincs11 ай бұрын
Can you give me an example? But I’d migrate without them and recompile what’s possible after.
@nitinpatil475211 ай бұрын
Any Behaviour/Breaking changes in DMA report
@saurabhk96 Жыл бұрын
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?
@redincs Жыл бұрын
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.
@yangryu6039 Жыл бұрын
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
@redincs Жыл бұрын
Try this approach: How To Restore SQL Database to a Lower Version kzbin.info/www/bejne/hafZZYppbb53has
@yangryu6039 Жыл бұрын
Thank you@@redincs
@briancastle6978 Жыл бұрын
how to add store procedure in sql
@redincs Жыл бұрын
Check my previous response to your comment.
@briancastle6978 Жыл бұрын
@@redincs this is the only procedure i have: dbo.rds_help_revlogin dbo.rds_hexadecimal dbo.rds_startup_tasks
@redincs Жыл бұрын
Have you added the backup and restore option group?
@briancastle6978 Жыл бұрын
Msg 2812, Level 16, State 62, Line 11 Could not find stored procedure 'msdb.dbo.rds_restore_database'.
@redincs Жыл бұрын
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.
@briancastle6978 Жыл бұрын
you didn't explain where did you get this code "exec msdb.dbo.rds_restore_database"