rds-backup

AWS RDS MSSQL Backup Manager

A command line tool to manage SQL backups on AWS RDS

• Sqlcmd or Docker installed
• AWS CLI installed and configured

• Feel free to download the latest version from release page, or
• use go get -u github.com/alexhokl/rds-backup if you have Go installed

rds-backup create -w --bucket your-s3-bucket-name --database your-database-name --password your-database-password --server your-rds-server --username your-rds-sql-server-login --filename filename-on-s3.bak

rds-backup create -r --bucket your-s3-bucket-name --database your-database-name --password your-database-password --server your-rds-server --username your-rds-sql-server-login --filename filename-on-s3.bak --container your-container-name --restore-password your-container-sql-password

rds-backup create -r -n --bucket your-s3-bucket-name --database your-database-name --password your-database-password --server your-rds-server --username your-rds-sql-server-login --filename filename-on-s3.bak --restore-password your-container-sql-password

You can avoid specifying some of the parameters every time by using a configuration file or environment variables or a combination of both.

bucket: your-s3-bucket-name
database: your-database-name
password: your-database-password
server: your-rds-server
username: your-rds-sql-server-login
filename: filename-on-s3.bak

export bucket=your-s3-bucket-name
export database=your-database-name
export password=your-database-password
export server=your-rds-server
export username=your-rds-sql-server-login
export filename=filename-on-s3.bak