I'm having difficulties exporting a Sql Azure database using Row-Level Security.

When using the Export method the following error occurs:

Error encountered during the service operation. Could not export schema and data from database. One or more errors occurred. Conversion failed when converting the nvarchar value 'D' to data type int.

Obviously the RLS causes these problems. But I don't see any other way to export the database.

I need to run a script to mutate data and making a backup beforehand would make me a lot safer.

Anyone got a working backup strategy?


This export button Export button

  • What export method you are using? Are you exporting to Azure SQL database? – SqlWorldWide Mar 24 '18 at 2:11
  • Updated the question. The export should create a .bacpac file. – rdkleine Mar 26 '18 at 7:24
  • Any luck on this? @rdkleine – judehall Jan 12 '19 at 19:49
  • I'm afraid not. There is a method I've wanted to try is to duplicate the database then remove RLS and lastly backup the database. This will lose the RLS obviously but I needed this for debugging purposes. – rdkleine Jan 15 '19 at 7:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.