Interesting Rename Refactoring Scenarios: Coalescing Two or More Objects

Here is another interesting use case for rename refactoring – coalescing two or more objects. What do I mean by that?   Well, this one is slightly different from what would traditionally be considered rename refactoring. It smells more like a semi-automated Merge Tables database refactoring.   Let’s say the scenario here is that you…

0

Interesting Rename Refactoring Scenarios: Name Consistency

One of the primary uses of database rename refactoring is driving naming consistency of your schema objects around organizational standards.   Naming Patterns There are many kinds of object naming standards. You could, for example, have a standard that all primary key column names must be suffixed with ID. Or you may use naming conventions…

1

MSDN Webcast: Gert and Sachin on Database Testing and Refactoring

Gert Drapers, Development Manager, and I did a MSDN webcast yesterday on Database Testing & Refactoring using Team Edition for Database Professionals. This is the third part of a four-part series on Team Edition for Database Professionals. I would encourage you to check it out! You can see me walking through exactly how you can…

0

Best Practice: Deploying Database Rename Refactorings

Team Edition for Database Professionals is targeted primarily at managing iterative changes for preproduction database development.   The primary use case for deploying rename refactorings is to your local sandbox server. The cleanest way to setup this sandbox server is to always drop and re-create the database at each deployment. Data can be regenerated for…

3

Book Recommendation: Refactoring Databases

I wanted to send kudos over to Scott W. Ambler and Pramodkumar J. Sadalage for recently publishing a great book on the very topic of refactoring databases. Refactoring Databases: Evolutionary Database Design http://www.amazon.com/gp/product/0321293533/104-1114081-9071168?v=glance&n=283155 I’m a big fan of this book. You’ll even find me saying so in the book’s foreword 🙂 Scott and Pramod have…

1

What is database refactoring?

Well, I’m glad you asked 🙂 The best way to explain database refactoring is to offer two different perspectives, depending on the background you are coming from. I offer a view on database refactoring both from the perspective of a seasoned application developer and a traditional database professional.   Application Developer View For most application…

9