So you cannot change schema in a transaction. So unless your installer only
updates data, it's not a useful conversation :)
How do we go about updating the db? We talk to our customers about their
deployment and upgrade strategy and train them. It involves a lot more than
clicking the installer
No transaction.
Standard operating procedure is that the admin makes a full backup before an
update. Point. Admins not doing backups - should be fired.
Run the script. Use transactions for small data changes - but nothing else. If
something goes wrong, tell the admin to put in his backup ;)
Do
2 matches
Mail list logo
