Rules

Secret ingredients to quality software

Edit
Info

Do you stop dealing with Data and Schema?

Last updated by Tiago Araújo [SSW] on 09 Mar 2021 05:05 pm (2 months ago) See History

Why don't most developers plan ahead? Take an average Desktop application that you sell to a few customers. When the customer wants a new version, there is no problem giving the customer the new exe. But what if you made a back-end structural changes to your database? Big hassle! You need to compare the database to remind you what was changed. Sure there are utilities for this - for Access back ends you can use SSW Data Renovator or for SQL Server back ends there is Red-gate SQL Compare - but why go to this trouble?

Version control for your Schema and where required your Data should be an important part of planning your projects.

For more information read Rules to Better SQL Server Schema Deployment.

Adam CoganAdam Cogan

We open source. This page is on GitHub