StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Your problem is a pretty common one, and I've had to deal with this kind of problem at my last job. There is another tool aside from the RedGate tool that may help you do what you need to do. It's a tool called DB Ghost. They explicitly address the versioning problem, and have a packager as well. I would suggest doing a trial of the DB Ghost product because they have some interesting claims concerning multiple version upgrades. This was taken from their FAQ (<a href="http://www.innovartis.co.uk/faqs/faqs.aspx" rel="nofollow noreferrer">http://www.innovartis.co.uk/faqs/faqs.aspx</a>):</p> <blockquote> <p>Q: Our problem is going to be managing data structure changes during upgrades. Our product line is Shrink-Wrapped, or downloadable from the website. So when a user downloads an upgrade, they can be upgrading from a very recent version, with few database structure changes, or the upgrade may be from a very old version with a multitude of structural changes. One upgrade needs to manage it all. The user would be offsite, so we can't hold their hand. We have users in Greece, Australia, Malaysia, Norway, etc. How would DB Ghost, if at all, handle updates in remote locations?</p> <p>A: The DB Ghost Packager Plus product was design to specifically address this issue as it can dynamically handle the required updates to a target database seamlessly.</p> </blockquote> <p>I'm just mentioning this because our company is trying to do something similar and I was doing research on this tool.</p> <p>Thanks, Eric</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload