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

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

トピック

移行と近代化データベース分析 AWS上の.NET

タグ

AWS Database Migration Service マイクロソフト SQL サーバー Amazon Relational Database Service (RDS)データベース AWS上の.NET

言語

English

Iknownothing

質問済み 1年前1098ビュー

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

エキスパート

Matt-B

回答済み 1年前

エキスパート

Giovanni Lauria

レビュー済み 1ヶ月前

Iknownothing
1年前
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 .

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

関連するコンテンツ