Tag: databases

Database “code” distinction

When considering how to improve dealing with changes to your database when releasing software, one simple distinction can help clear up a lot of confusion. There are two broad categories of things that change in a database. There are tables that contain data for your application. Unlike application code, these can’t be dropped and recreated each time you release. At…

What database schema comparisons can accomplish

When you wait until the last minute to deal with database changes, schema comparison is one of the tools necessary to reverse engineer what changed in your database. A schema comparison helps identify what changed about the structure of the database. For example, a table was added or a column was removed. Schema comparison doesn’t focus on what may or…