Re: updating database

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/03/04 

Date: Mon, 3 May 2004 16:34:41 -0400

> Now, based on your code sample, does it mean that we will have to code
seperately for each version (in the script) we have ever released to bring
the database up to date on the client's machine.. seems like a nightmare
situation.
>
> What are your views about that...

Having major upgrades, and not upgrading 80 times?

Or having atomic scripts so you can do far less conditionals, e.g.

 IF COL_LENGTH('table.col') IS NULL
    ALTER TABLE table ADD col INT
ELSE
    -- column already exists

> Also you mentioned that this kind of versioning system is not widely used.
I am sure many people must have our kind of software scenario.

Yes, but I doubt you will find a specific document that will walk you
through exactly what you want to do.

> what do you think is the best way to keep the database up to date on
client's machines.

I thought I went through that already?

Relevant Pages

  • Re: partnumber as string subtracts
    ... The only explanation that comes to mind a that something is different ... between the code sample given and the actual code treating the process ... Later on in my script I executed the ...
    (microsoft.public.sqlserver.dts)
  • Re: Issues with creating a shell script.
    ... and from the other script you mention. ... If "logger" can take an argument ... echo $1> $$LOG ... Post the smallest code sample with sample input and output that can reproduce the problem. ...
    (comp.unix.shell)
  • Re: Mapnetwork drive (not on the own machine)
    ... Thanks for your code sample, i changed it to my values and set the ... registry key on a testserver where the script should run. ... But when i run the script to remotly start the script, ...
    (microsoft.public.scripting.vbscript)
  • Re: [help] ALTER TABLE: error message 4929
    ... I've no more code sample to post, it's just a script with some ALTER TABLE to change columns name or type. ...
    (comp.databases.ms-sqlserver)