Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MattC123
Starting Member
1 Post |
 Posted - 2013-03-12 : 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.Thanks,MattC |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-03-12 : 07:45:34
|
| Side by side upgradation will be a good move,as you will still have the legacy system if anything goes wrong. |
 |
|
|
|
|
|
How Do I Approach a Major Upgrade to the DB