sql server - SqlPackage not exporting entire database -


i'm trying move large database (50gb) azure. running command on local sql server generate bacpac can upload.

sqlpackage.exe /a:export /ssn:localhost /sdn:mdbilling /su:sa /sp:somepassword /tf:"d:\test.bacpac"

the export not print errors , finishes "successfully exported database , saved file 'd:\test.bacpac'."

when @ bacpac in file system, comes out 3.7gb. there's no way 50gb database can compressed small. upload azure regardless. package upload succeeds, when query azure database of tables return 0 rows. it's if bacpac not contain database's data.

are there known limitations export method? database size, data types, etc?

i tried using 64bit version of sqlpackage reading experienced out of memory issues on large databases, wasn't getting error or error matter.

update/edit: made progress after ensuring export transactionally consistent restoring backup , extracting bacpac that. however, have run new error when uploading azure.

i receive following message (using s3 database):

error encountered during service operation. data plan execution failed message 1 or more errors occurred. 1 or more errors occurred. 1 or more errors occurred. 1 or more errors occurred. xml parsing: document parsing required memory 1 or more errors occurred. xml parsing: document parsing required memory

the problem resolved. issues two-fold.

first, because bacpac operations not transactionally consistent, had restore backup , make bacpac out of restored database. ensured users not adding rows while bacpac being generated.

second issue xml column in database. table has 17 million rows , of rows 250 them had large xml documents stored in them (200000+ characters). removing 250 rows , them reimporting solved problems. don't think size of xml document azure had issue with. think large documents contained special characters xml parser didn't like.

it's unclear me how sql server allows unparseable xml database in first place, other issue.


-

Comments

Post a Comment

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)...
Read more

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

i trying hit soap api in application login purpose , getting above mentioned error , can 1 tell me going wrong , first time soap apis. here code hit soap :- vector<object> args = new vector<object>(); hashtable<string, object> hashtable = new hashtable<string, object>(); hashtable.put("email", "mss.siddhart28@gmail.com"); hashtable.put("password", "siddharth"); args.add(hashtable); soapserializationenvelope envelope = new soapserializationenvelope( soapenvelope.ver11); envelope.dotnet = true; envelope.xsd = soapserializationenvelope.xsd; envelope.enc = soapserializationenvelope.enc; (new marshalhashtable()).register(envelope); httptransportse androidhttptransport = new httptransportse( "http://tempuri.org/", 15000); androidhttptransport.debug = true; string result = ""; try { soapobject request = new soapobject("http:...
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using ...
Read more