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 réponse
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
répondu il y a 4 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions