Dqsinstaller.Exe Exportkbs Does Not Export A Backup

Hi Everybody!

It’s been a long time; but, I’m at a great place, doing work I believe in, with people I love working with on a daily basis.  Lately, I’ve been working on my latest masterpiece, my first Enterprise Data Warehouse / OLAP solution that incorporates data governance using Microsoft Master Data and Data Quality Services (EDW / MDS / DQS.)  The engagement with the business is incredible.  Upper management is buying into the Kimball approach right down to the nine-steps.  This is truly an amazing time for me!

Okay on to why you’re probably here.  I had this problem again, 9 months after I had it before.  I had to scratch my head some more resulting in even more hair loss and I was reminded about how great it is to blog every now and then.  (Pragmatic Works FTW)

This guy had the same problem and in the interest of efficiency…

“I’ve tried numerous times to export my KBs from DQS.  I run the command line tool (runas admin on the cmd prompt)  and the command executes almost immediately with no errors and no backup file as I specified (dqsinstaller.exe –exportkbs c:\PDM\DQSBackup.dqsb)  I am on SQL 2012 SP1 CU 4.  This is all very frustrating. ”

Social.TechNet.Microsoft.com

Punch line:

dastardlydashingdash

https://msdn.microsoft.com/en-us/library/hh759340(v=sql.120).aspx

I don’t know if you can tell from the screenshot; but, the dash is dastardly different.

Type the command into notepad using your keyboard.  Copy and paste that into the command prompt window or your batch file and you should be good to go.