Schema Change/Update script for Database deploy
I have a need to change the database schema in my code and I made the
changes in the code and my local database and tested them. I'm planning to
write Schema change and update scripts for tracking database changes and
updating them. I followed
this article
for a start, I got a gist of what he is getting at however since I haven't
worked much on SQL scripts before a tutorial or something to start with
would be good. I did some research on the web and came to know that most
people use Automatic comparing tools to generate the script which I don't
want to do for obvious reason that I won't learn the process.
I'm looking for some tutorials/links on How to write Change scripts and
Update scripts ? Especially update scripts as I couln't find even a single
script/pseudo-code on how to do update schema by comparing SchemaChangeLog
table, connecting to the table using scripts...
Thanks in advance!
No comments:
Post a Comment