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

Question

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

Answer

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

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

相關內容