sql server - Management Studio error while generating Scripts -

-

i tried generate scripts our companies azure sql-database. did 2 weeks before connected db management studio client , run "generate scripts"-wizard in context of concerned db. wizard failed @ "getting list of objects 'db'." , pointed out following stack trace:

microsoft.sqlserver.management.sqlscriptpublish.sqlscriptpublishexception: error occurred while scripting objects. ---> system.invalidcastexception: die angegebene umwandlung ist ungültig. @ microsoft.sqlserver.management.smo.table.microsoft.sqlserver.management.smo.ipropertydatadispatch.setpropertyvalue(int32 index, object value) @ microsoft.sqlserver.management.smo.propertydispatcher.setvalue(int32 index, object value) @ microsoft.sqlserver.management.smo.propertycollection.setvalue(int32 index, object value) @ microsoft.sqlserver.management.smo.sqlsmoobject.addobjectpropsfromdatareader(idatareader reader, boolean skipifdirty, int32 startcolidx, int32 endcolidx) @ microsoft.sqlserver.management.smo.sqlsmoobject.implinitialize(string[] fields, orderby[] orderby) @ microsoft.sqlserver.management.smo.sqlsmoobject.onpropertymissing(string propname, boolean usedefaultvalue) @ microsoft.sqlserver.management.smo.propertycollection.retrieveproperty(int32 index, boolean usedefaultonmissingvalue) @ microsoft.sqlserver.management.smo.propertycollection.getpropertyobject(int32 index) @ microsoft.sqlserver.management.smo.sqlsmoobject.getpropertyoptional(string propname) @ microsoft.sqlserver.management.smo.column.embeddefaultconstraints() @ microsoft.sqlserver.management.smo.column.getpropagateinfo(propagateaction action) @ microsoft.sqlserver.management.smo.sqlsmoobject.getpropagateinfofordiscovery(propagateaction action) @ microsoft.sqlserver.management.smo.smodependencydiscoverer.getscriptablechildren(list1 propinfolist, propagateaction propagateaction) @ microsoft.sqlserver.management.smo.smodependencydiscoverer.sfcchildrendiscovery(hashset1 discoveredurns) @ microsoft.sqlserver.management.smo.smodependencydiscoverer.discover(ienumerable1 urns) @ microsoft.sqlserver.management.smo.scriptmaker.discover(ienumerable1 urns) @ microsoft.sqlserver.management.smo.scriptmaker.discoverorderscript(ienumerable1 urns) @ microsoft.sqlserver.management.smo.scriptmaker.scriptworker(list1 urns, ismoscriptwriter writer) @ microsoft.sqlserver.management.smo.scriptmaker.script(urn[] urns, ismoscriptwriter writer) @ microsoft.sqlserver.management.sqlscriptpublish.sqlscriptgenerator.doscript(scriptoutputoptions outputoptions) --- end of inner exception stack trace --- @ microsoft.sqlserver.management.sqlscriptpublish.generatepublishpage.worker_dowork(object sender, doworkeventargs e) @ system.componentmodel.backgroundworker.ondowork(doworkeventargs e) @ system.componentmodel.backgroundworker.workerthreadstart(object argument)

the @@version-query returns following record:

microsoft sql azure (rtm) - 11.0.9231.13 jul 15 2015 11:58:32 copyright (c) microsoft corporation

and here additional information copied ssms-help:

microsoft sql server management studio 12.0.4100.1 microsoft analysis services client tools 12.0.4100.1 microsoft data access components (mdac) 6.1.7601.17514 microsoft msxml 3.0 6.0 microsoft internet explorer 9.11.9600.17843 microsoft .net framework 4.0.30319.42000 operating system 6.1.7601

can tell me what's going wrong here?

thanks in advance.

alan

i had same problem . resolve switched directory sql server write .

worked me.

i hope solve problem , since error message not clear.


Comments

Post a Comment

Popular posts from this blog

yii2 - Yii 2 Running a Cron in the basic template -

-
i have seen instructions on running cron in advanced template, cant figure out how on basic template. have following controller in basic controllers folder. <?php namespace app\controllers; use yii\console\controller; /** * cron controller */ class croncontroller extends controller { public function actionindex() { echo "cron service runnning"; } public function actionmail($to) { echo "sending mail " . $to; } } i have navigated root of application , tried these comands yii cron php yii cron im getting unknown comand "cron" i know old question failed find actual answer this. if @ code yii exec file you'll notice requires /common/config/aliases.php file console/config/main.php. can naturally change these or copy on these advanced template. hope solves problem wanting same thing.
Read more

asp.net - 'System.Web.HttpContext' does not contain a definition for 'GetOwinContext' Mystery -

-
i realize question might seem trivial some, it's these types of things find myself fighting quite bit , want make sense of despite seeming losing battle in .net (for me anyway). so, if following: using system.web; ... applicationuser user = system.web.httpcontext.getowincontext().getusermanager<applicationusermanager>().findbyid(system.web.httpcontext.user.identity.getuserid()); that produces error in title , red getowincontext() , error cannot resolve symbol 'getowincontext()' however, if following (remove system.web in front of httpcontext ), works expected (or @ least no errors): using system.web; ... applicationuser user = httpcontext.getowincontext().getusermanager<applicationusermanager>().findbyid(system.web.httpcontext.user.identity.getuserid()); however, if (same line that's working using system.web commented out): //using system.web; ... applicationuser user = httpcontext.getowincontext().getusermana...
Read more

mercurial graft feature, can it copy? -

-
there new feature in mercurial 3, called 'graft' (graft local). job of moving change-set different branch. is there way "copy" change-set branch? i interested in in moving stuff qa branch production branch, still need code reside in qa. want copy. found , have tried few things, maybe it'll become clear more tinkering , reading... does have better way of 'cherry picking' change-sets move cross branch (or trunk)??? graft copies changesets, doesn't move them. hg graft (emphasis mine): this command uses mercurial's merge logic copy individual changes other branches without merging branches in history graph. known 'backporting' or 'cherry-picking' . default, graft copy user, date, , description source changesets.
Read more