Hi,
I just tried to update my website to use latest Swift version (from 1.21.0 to 1.26.4). I'm on DW version 9.17.6
I've noticed that there's quite a lot of database changes in swift item types. So, what is the recommended approach to update the database? I cannot just grab the demo website and overwrite my existing databse as of course I'd lose all my content and I'd have to start from scratch with the website. So that's not an option.
I tried to just delete all the tables that start with ItemType_Swift and make DW recreate them at startup. And it does, but again that means that I've just lost all the data that were there so my website won't even start.
I also tried to use the schema comparison tool and comppared a default Swift db with mine. It picked up all the differences and generated schema update scripts. But I get a ton of errors from that as well as it complains that would be a "data loss operation". This script is huge so I won't get into details of that here but in general - using that is not an option too.
So... what's the recommended approach? How can I update swift on the existing website that I have? Do you have any script that would just apply incremental schema changes?