SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripting Indexes

I was recently reading a blog posting on BIDN, Scripting Indexes with Filters and schemas.  In the posting the author explained the challenges of trying to script only indexes using SQL Server Management Studio (SSMS).  Moreover, the author adds that there needs to be an option to filter what is scripted.

Ironically, a fellow colleague and I experienced a very similar problem and decided to write a small application that should fulfill all of the requirements outlined by the blog posting with the exception of the schema filtering.  However, the application does allow you to select only the indexes that you need.   We started working on this approximately a year ago, but never really put too much effort into finalizing it.

After I read the posting I gave my friend a call and he finished the application and we launched a site, http://www.dbscripttools.com/.  We have done some preliminary testing, but before we start distributing it to the masses we are looking for few brave individuals to do some additional testing.  If you are interested please feel free to sign up as a Beta Tester on the site and we will send you a URL to download the application.  In return, when all the testing is complete, you will be the first to receive a finalized copy of the application.

Talk to you soon,

Patrick LeBlanc, founder SQLLunch.com and TSQLScripts.com

Visit www.BIDN.com, Bringing Business Intelligence to your company 



No comments.

Leave a Comment

Please register or log in to leave a comment.