I am taking a backup file with schema and data using a backup SQL script. It is updated in the S3 bucket with schema and data also but I want only the schema backup file and directly uploaded into S3 bucket. what is the process?
Loading
I am taking a backup file with schema and data using a backup SQL script. It is updated in the S3 bucket with schema and data also but I want only the schema backup file and directly uploaded into S3 bucket. what is the process?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Mohammad HussainPosted Sep 7, 2023, 2:10 PM
Try This...
Amit MohantyPosted Sep 6, 2023, 6:12 AM
To generate a schema-only backup script you can use the Generate Scripts wizard in SSMS to create a script that includes only the schema (tables, views, procedures, etc.) without data.
Tasks>Generate Scripts.This will generate a script containing the schema of your database.
Now save the generated script to a local file, such as schema_backup.sql and you can use the AWS CLI to upload the schema_backup.sql file to your S3 bucket: