<< Extend Anonymous Types using Reflection.Emit | Home | Search the source of SQL Server views and stored procedures >>
kick it on DotNetKicks.com   Shout it  

Better Generate Scripts Tool for SQL 2005

Frustrated by the inability to script SQL Server 2005 objects with BOTH a CREATE and DROP statement? Generally, I write all my scripts with both statements and then save them and include them in source control, so this hasn't really been a problem for me. But I recently started working on a new project where stored proceedures haven't been maintained in source control and the generate scripts tool is used to sync changes between environments and there are a lot of stored procedures.


So I decided to google for a way to get around this. Greatfully the SqlTeam has created an app named "Scriptio". It lets you generate both CREATE and DROP and has very flexible options similar to SQL 2000 options. You can find it here:


http://www.sqlteam.com/publish/scriptio/.


And for credit where it's due, here's where I heard about it:


http://weblogs.sqlteam.com/tarad/archive/2006/09/20/12374.aspx.


Thanks to Tara Kizer!

Tags: , ,

Print posted @ Wednesday, February 13, 2008 11:12 AM

kick it on DotNetKicks.com   Shout it  

Feedback

# 

Gravatar The scriptio tool is good but it CANNOT generate the table scrips in totallity. Defaults are ignored by the app 6/4/2008 7:37 AM | noreply@blogger.com (Anonymous)

# 

Gravatar You're right. I hadn't noticed that since I have only used it for scripting stored procedures. When I start on a new project which isn't using source control for stored procedures, I script them all out and add them to source control. Since I manage changes to tables differently I hadn't really used scriptio for that. 6/4/2008 8:10 AM | noreply@blogger.com (Mark J. Miller)
Post a comment





 

Please add 1 and 6 and type the answer here:

 

 

Copyright © Mark J. Miller