Hi,
We have a DW10 solution in an Azure hosting. I cannot figure out how database changes are done when upgrading a solution? I am missing "EndpointHeaders" from the EndPoint table.
Regards
Hi,
We have a DW10 solution in an Azure hosting. I cannot figure out how database changes are done when upgrading a solution? I am missing "EndpointHeaders" from the EndPoint table.
Regards
Hi Aki,
The database schema is updated through so-called update providers. There are multiple of these in various assemblies, in fact you can even create your own if you need updates to run on deployment. Updates are very versatile and can be used to anything from moving/copying files to, relating to this thread, database updates.
When the solution starts up after an upgrade, it will loop through all update providers and run all updates that have not already been registered as completed. In the database, there's a table called Updates which contains the list of installed updates. It shows the update id, the provider it came from and the timestamp for when it was installed.
Regarding the specific column you mention, it's actually installed with the default database layout when installing DynamicWeb through the Setup guide and not an update. If that column is missing from that table, it indicates that the database was not created correctly. It's hard for me to say how that could have happened. Did you copy the database from somewhere or did you start it fresh with the solution? I just checked that it is part of the Swift database release.
- Jeppe
Hi,
Thanks for that info Jeppe. In this case we did an upgrade of an DW9 solution. Maybe I can just add it manually in this case, I have another DW10 solution where I can see it so I know what to create.
I'll take a look at the Update table also.
Regards / Aki
Out of curiousity, do you know which version of DW9 you upgraded from?
Must have been 9.16.4 and I then realise that it should have been upgraded to 9.17+ before that so it my bad. :)
Good to know the source of the problem anyway. And if we run into so similar problem I will know why.
/Aki
You must be logged in to post in the forum