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

migrating SQL Server databases with file stream to AWS Custom RDS

0

Hi Team,

As we know, file stream databases are not supported in RDS, so we plan to custom RDS SQL Server. I think it will be the same as on-premises. could you please share any AWS links for migrating file stream DBs to custom RDS?

Thanks

1 Answer
0

You can perform a native backup onto a file and upload the file to S3.

BACKUP DATABASE mydatabase TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup\mydb-backup.bak' WITH COMPRESSION;

Please find in the doc: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-migrating.html https://www.sqlops.com/migrating-databases-to-aws-rds-a-step-by-step-guide/

profile picture
EXPERT
answered 5 months 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