tag:blogger.com,1999:blog-2496415891665263000.post126671132007260288..comments2023-10-12T13:08:57.828+02:00Comments on For the Love of Software: Scripting SQL Server database objects using SMOHesham A. Aminhttp://www.blogger.com/profile/00063404912692423973noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-2496415891665263000.post-88870566869073300132010-09-14T08:30:54.603+02:002010-09-14T08:30:54.603+02:00@Anonymous:
It's great to see other developers...@Anonymous:<br />It's great to see other developers extending this tool.<br />You can share your changes using your skydrive account (http://windowslive.com/online/skydrive). It's free. You just need a windows live id (hotmail account).<br />And don't forget to post the link :)Hesham A. Aminhttps://www.blogger.com/profile/00063404912692423973noreply@blogger.comtag:blogger.com,1999:blog-2496415891665263000.post-3101607410829052802010-09-14T05:07:55.569+02:002010-09-14T05:07:55.569+02:00I made a few upgrades to this. I stopped it duplic...I made a few upgrades to this. I stopped it duplicating dependencies. It also creates the bindings (like applying defaults to UDDTs). Also outputs schemas and schmea qualifies FK references. I can't see a way on this site to email it too you though...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2496415891665263000.post-43652840922664529732010-02-03T08:41:08.139+02:002010-02-03T08:41:08.139+02:00ScriptWithList() writes to the output file specifi...ScriptWithList() writes to the output file specified.Hesham A. Aminhttps://www.blogger.com/profile/00063404912692423973noreply@blogger.comtag:blogger.com,1999:blog-2496415891665263000.post-39900511004989718412010-02-03T07:13:42.047+02:002010-02-03T07:13:42.047+02:00Oops. Nevermind. :)
The sample doesn't have th...Oops. Nevermind. :)<br />The sample doesn't have the source code.<br />The last line in the blog post is: _scripter.ScriptWithList(dc);<br /><br />What picks up the output of the ScriptWithList() method?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2496415891665263000.post-68041443657199131122010-02-03T07:07:42.465+02:002010-02-03T07:07:42.465+02:00Does anyone still have the sample code? The downl...Does anyone still have the sample code? The download link is dead.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2496415891665263000.post-74902458179873255972009-04-16T16:08:00.000+02:002009-04-16T16:08:00.000+02:00I don't know why this would be different than ...I don't know why this would be different than when you ran this on your machine, but on mine (Vista64), the args collection is clearly getting parsed differently.<br /><br />Instead of the second half of each arg just *being* the second half, like your code implies it is on your side (i.e. for -server:SERVERNAME, SERVERNAME is a substring of the same arg as -server:), on my side, -server and SERVERNAME are 2 separate args.<br /><br />Not a big deal to change, but thought you might want to know. Here's the updated contents of the SetParameter method:<br /><br />private static void SetParameter(string name,string[] args,out string value)<br /> {<br /> name="-"+name+":";<br /> for (var i = 0; i < args.Length;i++ )<br /> {<br /> String arg = args[i];<br /> if (arg.StartsWith(name, StringComparison.CurrentCultureIgnoreCase))<br /> {<br /> value = args[i + 1];<br /> return;<br /> }<br /> }<br /> value = null;<br /> }Unknownhttps://www.blogger.com/profile/10813365042401015041noreply@blogger.comtag:blogger.com,1999:blog-2496415891665263000.post-4909150190355149102009-03-06T12:20:00.000+02:002009-03-06T12:20:00.000+02:00Really very helpful for the SMO begginers some one...Really very helpful for the SMO begginers some one like me :-). I was struggling to understand the usage of Dependency walker. Thank you Hesham.<BR/><BR/>Cheers<BR/>BharathAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2496415891665263000.post-15900338996446361992009-01-19T23:36:00.000+02:002009-01-19T23:36:00.000+02:00Very helpful post! This was a big help to me and ...Very helpful post! This was a big help to me and I am so glad that I found it. Thank you so much!<BR/><BR/>TimAnonymousnoreply@blogger.com