How To Migrate SQL Server Database To AWS RDS

[@redincs]

*** 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

[@vaibhavverma1340]

Hello - Thank you so much for the tutorial, can you please share how to upload the tables from database into RDS ??

[@ChanceTEK]

Brilliant video. Illuminating. Thank you.

[@redincs]

You're very welcome

[@bobsukki]

Thank you for sharing this knowledge! Good stuff

[@redincs]

I appreciate you feedback!

[@luis-ibarra-consiglieri]

Great video, works perfectly... thank you!

[@redincs]

You're welcome!

[@RealWellnessWarrior]

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

[@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

[@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.

[@naod1989]

Can you do one video of migrating SQL server DB from EC2 to RDS, please? Thank you

[@redincs]

Let me know if this helps: kzbin.info/www/bejne/sKuqgoWZpcZkf5I

[@naod1989]

@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

[@emarversity]

Correct@@naod1989

[@stouttaaddis989]

Getting this error on the script.....Could not find stored procedure 'msdb.dbo.rds_restore_database

[@redincs]

Remove and re-add the options group and reboot.

[@Mohinipatil-l9p]

How you are handing the Discrepancies found in DMA report as source is 2014 and Target is 2017

[@redincs]

Can you give me an example? But I’d migrate without them and recompile what’s possible after.

[@Mohinipatil-l9p]

Any Behaviour/Breaking changes in DMA report

[@bn_castillo]

how to add store procedure in sql

[@redincs]

Check my previous response to your comment.

[@bn_castillo]

@@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?

[@bn_castillo]

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.

[@bn_castillo]

you didn't explain where did you get this code "exec msdb.dbo.rds_restore_database"

[@redincs]

Here: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html