Post reply

Scripting with the Script Wizard

  • February 13, 2006 at 9:56 am

    #166855

    Hi,

    I've been trying to script out some objects from a 2005 database in Management Studio. There’s an excellent tool called the Script Wizard but as far as I can see, which may not be that well at the moment, it doesn’t cater for scripting out the selected objects to individual files by object name. It seems that it dumps all the selected objects into 1 file.

    Does anyone have a work around or some SMO\DMO code to run from SSIS? The SMO code would be excellent as I’ve isolated some procs and UDF’s that I’d like to script out to individual files. Only thing about SMO\DMO is that I’m really not that proficient at it

    Many thanks

    Max

  • February 14, 2006 at 8:44 am

    #620716

    Individual files were an option in 2000. Another lost featue! Also, you can not scrip drop and add at the same time, or preview the TSQL.

    You will be upgraded. Resistance is futile!

  • February 14, 2006 at 9:05 am

    #620729

    but why, WHY!!! All I wanted was to script some procs, maybe some udf's, not too much to ask for. Why did this have to happen to me!

    Ok, I'll stop being silly now. As far as I can discern we're suppossed to use SMO for more detailed scripts instead. Unfortunately not everyone has the opportunity to learn this pronto when projects have tight deadlines. I'll give 'em this though; very nice coding possibilities.

    http://msdn2.microsoft.com/en-us/library/ms162160.aspx

    Got a bit of a programming background though, should be alright for the new vision.

    Max

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply