2008/9/1 Alan McDonald <alan@...>

> > I need to upgrade several databases (1.5 & 2.0) to 2.1 in the near
> > future. I
> > was planning on doing the standard "backup with old version, upgrade,
> > restore with new" method but realised that means the old udf's will be
> > carried forward whereas I want to use the new built-in version.
> >
> > I'd rather not have to do each one manually, any suggestions for a
> > scripted method
> >
>
> you mean in all your triggers and SPs?
> If so, I would register 2 copies of the DB in your favourite admin tool
> (source and target).
> Do a search and replace on old UDF functions to change to new ones, or edit
> manually as required until you make all the changes required.
> Then do a DB compare (many tools for this) to create an update script.
> Then test the Update script/backup/restore cycle on the target DB. And test
> again and again to make sure before you deploy :-)
> Alan

nice theory but each database is slightly different in ddl and/or data so
I've have to do this for each database


[Non-text portions of this message have been removed]