Reasons to avoid "live" editing inside the db
Today I hit a major problem with WebDav: when I tried to get good working copies of my XML files out of the db, by mounting it as a share through WebDav, most of the XML documents came out with dozens of trailing #0 characters, which of course are very hard to deal with; they make the file invalid, but you can't easily search-and-replace them. I had to unmount and remount several times, and copy-paste the files in small batches, to get a good copy of my data. It took me ages to clean it up and confirm it was clean. I need to edit externally because of the XInclude issue mentioned in my last post, so I'm now going to abandon the data explorer approach, and work in a more conventional way:
- All data in SVN (not set up yet).
- Checkout / edit / commit.
- Upload to db when ready.
I'll make sure the SVN permissions are set so that the site data can't be changed by the data editors.