Sql scripting tool

Last Post 17 Dec 2008 09:32 AM by Dan Sweet. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Dan Sweet
New Member
New Member

17 Dec 2008 09:32 AM
I just read the article on the SQLScripter tool in the November SQL Server mag. It looks interesting, but is dependant on the SQL 2005 + object model. Many years ago I wrote a set of stored procedures useing ole automation to do the same job. In short, it allows me to capture a copy of SQL scripts for all the objects in a database. It archives these copies every day for a week, every week for a month, month per quarter and quarter for the year. It has proven invaluable as a form of source control in environements where anybody and everybody updates sql objects with whatever tool strikes their fancy. It runs on SQL 7.0, 2000 and 2005, and I'm sure will work so long as SQL Server supports the ole automation procs.

Acceptable Use Policy