Posted - 03/12/2013 : 07:41:10
| I work in a small shop. We provide Maintenance and Development for a large facilities maintenance package. We are now in the process of upgrading that package. Over the years we have heavily customized the db. Here are some facts on the upgrade:
- 500 tables in the new "out of the box" package
- 800 tables in the current system
- 120 tables modified in the latest version of the package that have also been customized by us.
Many constraints, stored procedures, ect. A large portion of these have been customized by us over the years.
This is a pretty large undertaking and I will be doing it myself. I'm interested in how other people have approached this type of thing. One of the big issues I am running into now is that when I try to update the existing db I run into all sorts of errors because of the constraints.
Any Suggestions, or lessons learned, would be greatly appreciated.