Do you stop dealing with Data and Schema?
  v7.0 Posted at 26/05/2017 10:08 AM by Andrew Campey

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​

​We have a program called SSW SQL Deploy to solve this problem and automatically make schema changes.

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address: