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 回答
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
专家
已回答 4 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则