Enabling extended admin privileges in amazon rds?

I wanted to set up RDS instance store data for reporting. I have scripts that trigger different rest calls on some sites that require basic admin privilege in the background because they dump their rest of the call data to csv and then bulk insert csv into Sql Server SE. In my local environment, setting up a user for my scripts to use with bulk admin rights was straightforward. However, I couldn't figure out how to do this in RDS. I opened a ticket from Amazon and they offered to write a policy for it. So I figured I'd ask here, is this possible and possible alternatives? If Bulk / System Administrative Privileges cannot be allowed in RDS, I guess I would just need to use an AWS EC2 instance with Sql Server installed on it.

+3


source to share


1 answer


Massive insertion is not possible with RDS. The data_file

command parameter BULK INSERT

must refer to a file accessible by the machine running SQL Server.

Also, RDS does not support the server role bulkadmin

.



Supported SQL Server Roles and Permissions

Importing and Exporting SQL Server Data

+1


source







All Articles