I am using SQL Server on my server (Windows Server ’12) and I am able to connect to the RDS server and I want to shift my database which is locally present to the RDS, is there any way to restore the database by just writing a SQL query?
I tried to copy of the script (script database as > create to > clipboard)
CREATE DATABASE xyz
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'xyz', FILENAME = N'https://zyx/public/xyz.mdf' ,
I have tried to host the .mdf file but this is not working as I am getting an error
CREATE FILE encountered operating system error 86
Recognized by AWS
1
You should use RDS native backup. Put your mdf in S3, set appropriate permissions and run stored procedure that AWS provides