How to deliver database schema changes?

Posts   
 
    
mario.muja avatar
mario.muja
User
Posts: 37
Joined: 03-May-2005
# Posted on: 02-Jun-2005 10:12:26   

Hi, let's assume, an entity collection has been transferred to another process. How can I update the entity objects residing in this other process in case a field has been added to one of the related database tables?

If it would be a database table and not an entity collection, then I would simply execute an SQL script to update the schema on the client, but how can I ensure that remote entity objects receive a schema change and update their structure (e.g. providing a new property)?

Regards, Maro

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 02-Jun-2005 11:47:20   

By using assembly signing and giving your application's assemblies a higher assembly version when the schema changes and you then use a similar mechanism like Reflector uses too: you use a stub which starts up your app, checks a webservice if newer assemblies are available, if so, download the newer versions. You can also use .NET's functionality on that (together with the signing) by specifying a remoted location for the assemblies using a codebase definition. .NET will then download newer versions if available.

Frans Bouma | Lead developer LLBLGen Pro