The amount of time the feature could save.This list was pruned based on a relative value that I assigned to each one according to: Others are less intrusive and do not change the database schema or SQL statements at all.ĭuring the design of SQL Refactor, I identified nearly forty potential features that could help to increase the productivity of the SQL Server developer or DBA.
Some of the utilities can be classified as refactoring utilities, which change the SQL code or the schema without affecting the behaviour of the database. SQL Refactor is a collection of utilities that are designed to aid the process of exploring legacy code, speed up schema changes and generally facilitate every day database development.
It is much more common to be required to work on established databases, and on SQL code that has been written by a previous developer or a colleague. In this article he describes its major features and utilities and provdes some insight into the development process behind it.ĭesigning and creating a new database is a well-researched task but, in my experience, it is certainly not what database administrators and developers spend most of their time doing. Faster Database Development with SQL Refactor - Simple TalkĪndrás Belokosztolszki was the lead developer on SQL Refactor.