Cannot export Azure SQL database


Cannot export Azure SQL database



When I try to export my database via the 'Export' button in the Azure portal, I get the following error:


Error encountered during the service operation.
Could not extract package from specified database.
The element DataSyncEncryptionKey_8d263adb59574052847134070b69d73d is not supported in Microsoft Azure SQL Database v12.



Though I did at one point try the DataSync service, I never ended up using it and am certainly not using it now. I regret even trying this service because it created schemas in my database that I do not know how to remove completely.



Now, it seems that these schemas are preventing me from exporting my database.



At the very least, it would be nice to resolve this error. However, it would be better if I could remove all traces of the DataSync service.



Please note that I have already used the script in the accepted solution to this question: How to remove SQL Azure Data Sync objects manually. That removed the DataSync schema but I am still left with the 'dss' and 'TaskHosting' schemas.



I have also tried emailing support, as recommended by the accepted solution in this thread: https://social.msdn.microsoft.com/Forums/azure/en-US/8b68b44b-c98a-4b38-8aab-36a30a7fafd9/the-element-datasyncencryptionkeyid-is-not-supported-in-microsoft-azure-sql-database-v12-when?forum=ssdsgetstarted. That email simply bounced back.



Additionally, if I go into Azure portal, it does not show any sync groups or sync agents whatsoever.




1 Answer
1



I hope you have asked this question prior to proceed performing the steps outlined on those old forum threads that were created when SQL Data Sync 2.0 did not exist. SQL Data Sync is no longer in preview, this month went to GA and has a deprovision utility available.



On the computer where you installed SQL Agent, under the c:program files (x86)Microsoft SQL Azure Data Sync directory you should find an utility named deprovisionUtil.exe. If you run it with the switch /F it will remove the DSS schema and all its objects.



If this is not possible now, please create a support ticket. Azure Support will clean up the sync database.





Thank you so much for your reply. I have never installed the SQL Agent on my local computer. I am on a Mac. I was using sync between two Azure databases - not a local PC. Unfortunately, I do not have a paid support plan, so I cannot create a support ticket. Is paying for a support plan my only option now?
– Fonnae
2 days ago






Thinking more about this, I do have access to a Windows PC with SSMS and so I suppose I could install the SQL Agent and attempt to use the utility like you described but I'm not sure if that is appropriate given that I have never used it before.
– Fonnae
2 days ago





It is difficult to know to what extent you manually deleted objects and what is left. Try to establish a sync between that PC and your SQL Azure Database and if successful then use the deprovision utility, but this may not work.
– Alberto Morillo
2 days ago






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

PySpark - SparkContext: Error initializing SparkContext File does not exist

Image
PySpark - SparkContext: Error initializing SparkContext File does not exist I have small piece code in PySpark, but I keep getting errors. I'm new to this so im not sure where to start. from pyspark import SparkContext, SparkConf conf = SparkConf().setAppName("Open json").setMaster("local[3]") sc = SparkContext(conf = conf) print("Done") I ran this in cmd with the command : spark-submit .PySparkOpen.py I then get the following error statement: C:UsersAbdullahDocumentsMaster Thesis>spark-submit .PySparkOpen.py 18/06/30 15:21:58 WARN NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-Java classes where applicable 18/06/30 15:22:01 ERROR SparkContext: Error initializing SparkContext. java.io.FileNotFoundException: File file:/C:/Users/Abdullah/Documents/Master%20Thesis/PySpark/Open.py does not exist at org.apache.hadoop.fs.RawLocalFileSystem.deprecatedGetFileStatus(RawLocalFileSystem.java:611) at...
Read more

List of Kim Possible characters

Image
From left to right: Wade (on monitor screen), Dr. James Timothy Possible, Mrs. Dr. Ann Possible, Ron, Rufus, Kim Possible, Shego, Dr. Drakken, Monkey Fist, Señor Senior Sr., Adrena Lynn, and Señor Senior Jr. This is a list of characters appearing in the animated series Kim Possible . Team Possible Kim Possible Main article: Kim Possible (character) Voiced by: Christy Carlson Romano and Dakota Fanning (Preschool Kim; Kim Possible: A Sitch In Time ) Kimberly Ann “Kim” Possible is a crime fighter and high school cheerleading captain who saves the world on a regular basis while dealing with the normal challenges of being a teenager, such as winning cheer competitions, turning in her homework on time, and maintaining a love life. Her name is a play on the word “impossible.” Kim has known Ron Stoppable, her sidekick for most missions, since preschool. She has also completed missions with Wade, Monique, her brothers, and even her mother. In season four, Kim and Ron end up developing romanti...
Read more

Python Tkinter Error, “Too Early to Create Image”

Python Tkinter Error, “Too Early to Create Image” So I have an assignment that I have to use Tkinter to create a board game. This is just one part of the program where I want to bring in the image of the board. But I keep on getting the error, "Too early to create image" and I'm not sure what I'm doing wrong. Here's my code so far: from Tkinter import * from pprint import pprint # Which variable is currently updating from variableColors import Variables VariableIndex = 0 VariableText = Variables[VariableIndex] Ids = None # Current canvas ids of the text and 4 player tokens: # Will be None if not committed VariableCoords = { } # Where store variable and coordinates im = PhotoImage(file="C:UsersKikiDesktopAssignment\") photo = can.create_image(0,0,anchor=NW, image=im) can.pack() root.mainloop() Any help would be appreciated. Thanks :) 1 Answer ...
Read more