By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

How to migrate a Microsoft SQL server with custom deployed stored procedure to RDS for Microsoft SQL SERVER

0

Hi, We are evaluating to migrate our dot net framework based application using the SQL server as data base to AWS cloud.We are evaluation the RDS for SQL server as possible option for database , however the current application has a of dependency on custom build stored procedure ( keeping a lot of business logic) . Can we use RDS option for SQL server has option to use custom stored procedures and function . Also is there option to migrate the data as well as SP and function to RDS for SQL server.

Unfortunately , I do not have much exp with SQL server and Window based application , hence i am bit clueless . Any help would be appreciated

Topics
Migration & ModernizationDatabaseAnalytics.NET on AWS
Tags
AWS Database Migration ServiceMicrosoft SQL ServerAmazon Relational Database ServiceDatabase.NET on AWS
Language
English
Iknownothing
asked a year ago1084 views
1 Answer
1

Hi There

There are a few ways to do the migration from SQL Server to RDS SQL. The easiest way would probably be a backup/restore which would include your database objects like stored procedures, as well as the data. See https://docs.aws.amazon.com/dms/latest/sbs/chap-manageddatabases.sql-server-rds-sql-server-full-load-backup-restore.html

profile pictureAWS
EXPERT
Matt-B
answered a year ago
profile picture
EXPERT
Giovanni Lauria
reviewed a month ago
  • Iknownothing
    a year ago

    Hey Matt , Thanks for the pointing out to the documentation. Since , it's took some time for me to comment as i wanted to test the solution.Yes the backup and restore keeps the original objects so in theory it works but we had some libraries and utilities that were not natively supported by the RDS versions , hence we need to refactor some stuffs .

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content