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

DMS full load for RDS SQL server

0

Hi Team,

I am planning to do the Full load using DMS from the on-premises SQL server to the RDS SQL server. As we know full load only load the data and we need manually migrate the Views, stored procedures, functions and indexes. does any way to migrate all objects to rds.

maybe a script out the indexes and view etc. causing a lot of manual work.

Topics
Migration & ModernizationDatabase
Tags
Migration & ModernizationAWS Database Migration ServiceMicrosoft SQL ServerDatabase
Language
English
Sanjeev_K
asked 2 years ago608 views
1 Answer
1
Accepted Answer

If you need to migrate the full database, you might consider using native migration tools.

Save your backup to S3 and then restore it on your RDS instance using the dedicated stored procedures.

See more in the documentation on Importing and exporting SQL Server databases using native backup and restore

AWS
adrian-AWS
answered 2 years ago
profile picture
EXPERT
Oleksii Bebych
reviewed a year ago

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