sql - Schema Change/Update script for Database deploy -


i have need change database schema . i'm planning write schema change , update scripts tracking database changes , updating them. followed

versioning databases – change scripts

for start, got gist of getting @ since haven't worked on sql scripts before, tutorial or start good. did research on web , came know people use automatic comparing tools generate script don't want obvious reason won't learn in process.

i'm looking tutorials/links on how write change scripts , update scripts ? update scripts couln't find single script/pseudo-code on how update schema comparing schemachangelog table, connecting table using scripts...

thanks in advance!

i recommend using database migration tool liquibase.

each change database captured changeset , liquibase automatically keep track of changesets have been applied database, enabling updates , rollbacks.


Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -