DMS full load for RDS SQL server

Question

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.

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 ](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html)on Importing and exporting SQL Server databases using native backup and restore

DMS full load for RDS SQL server

Contenuto pertinente