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

1回答
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
エキスパート
Matt-B
回答済み 2年前
profile picture
エキスパート
レビュー済み 7ヶ月前
  • 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 .

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ