Add new functions/Update functions from a new build of assembly

Jun 7, 2009 at 1:37 PM
Edited Jun 8, 2009 at 4:34 AM

Hi everyone.


I created a new database, then use the msscmd to deploy the mssqlspatial assembly and its functions/triggers/aggregates.
It works fine, however after I made some changes to my table valued function, how can I update or add this function into the database?

Currently I drop and recreate that database, and redeploy the new assembly. But then I lost all the data.

Cheers

Jun 8, 2009 at 4:46 AM

I think I got the answer from: 

http://support.microsoft.com/kb/917407

When you want to downgrade a strong-named assembly, follow these steps:

  1. Drop all objects that depend on the assembly.
  2. Drop the newer version of the assembly.
  3. Create the older version of the assembly.
  4. Create all required objects that depend on the assembly.
Jun 10, 2009 at 9:46 PM

Just found the deployment process already covered all the 4 processes mentioned in my previous reply.