Generate scripts only for stored procedures and views?

Hello, I have two environments, testing and developing, sometimes on developing environment I make chagnes to views or stored procedures, the first time I copied the whole database, but when the tester began to test the second cycle I made the same and he losed the changes, the tables wont change, but the views and sps may change, so I need an easy way to change those objects without having to copy all the database?

I tried but the generate scrips task but I didnt see an option to script only views and procedures.

What version of SQL Server are you using? I'm using SQL Server 2005 Express, and when I go through the script wizard to script objects, I see the "Choose Object Types you want to script." just fine.

In Object Explorer, right-click on your database -> Tasks -> Generate Scripts...

|||I am using sql 2005 developer edition and I dont see that option anywhere.|||what option don't you see where and at what point?|||Did you complete the wizard? I remember that option near the end of the wizard.|||You were right, it was in the last step. I really would think to put it in the first step. Its just my opinion but thanks.

Generate Scripts missing option in Management Studio

I was hoping this would be fixed in SP1, but it is still missing. Particularly in a development environment, I find it very useful to have scripts DROP first, then do a CREATE for tables. There is an option called Script Behavior that is supposed to allow this, according to the help text. There are supposed to be 3 options, DROP only, CREATE only and DROP + CREATE. This third option (the one I need) is missing. It does not show up on the drop down.

Sorry, I don't want to be rude, but before anyone suggests it, yes, I know I can create a DROP script first and then go back in and create a CREATE script and then run both. And I don't want to change my methodology, and I don't want to do twice the work. All I would like to know is if anyone knows how to get this 3rd option to appear, or if its a known bug, is there a hotfix or a plan to fix it soon.

Thanks,

Wayne

You need to try the Tools forum, this is SSIS.

-Jamie

|||

Hi,

Sorry, I thought Generate scripts was considered a SSIS function like Import/Export. I'll repost over in the other forum.

Thanks,

Wayne

Generate Scripts missing option in Management Studio

I was hoping this would be fixed in SP1, but it is still missing. Particularly in a development environment, I find it very useful to have scripts DROP first, then do a CREATE for tables. There is an option called Script Behavior that is supposed to allow this, according to the help text. There are supposed to be 3 options, DROP only, CREATE only and DROP + CREATE. This third option (the one I need) is missing. It does not show up on the drop down.

Sorry, I don't want to be rude, but before anyone suggests it, yes, I know I can create a DROP script first and then go back in and create a CREATE script and then run both. And I don't want to change my methodology, and I don't want to do twice the work. All I would like to know is if anyone knows how to get this 3rd option to appear, or if its a known bug, is there a hotfix or a plan to fix it soon.

Thanks,

Wayne

[moved/reposted from SSIS forum]

I believe this is on the list to be fixed in the next SP.