Projects that refused to cooperate? Last May I started on a SQL Server migration from SQL2000 to SQL2012 and it has been kicking my rear end because the software that connects to it is as old as SQL2000 and migrating database software that far apart in age isn’t recommended.
November of last year after getting all of our ducks in a row, I built the server, got the OS and SQL all set up but that was the easy part. We made the first attempt and nothing seemed to work, we kept getting errors and huge CPU spikes that didn’t make sense. Then each month thereafter we made new attempts, this drove my boss batchit and frustrated, you can imagine how it made me feel.
I refused to move forward unless certain issues could be over-come, it either works like it should or we can’t move forward. Finally while working on another project which happened to include the very person who wrote the software we were using (not SQL) I asked him for help and he thankfully said yes. The problem wasn’t in the migration, itself complicated enough for sure, nope, the problem was with the license files the equipment uses to make sure these systems are paid for and it turns out we had some with faulty code in the license files.
Considering the newest server I built with these license files is now going on 7 years old who would have thunk it would be a license file?? Sure enough he found the problem and fixed it and today after working an all nighter and now on my 2nd pot of coffee we are almost done with the migration. There are several jobs that have to be modified to work with the new DB but we’ll get there…
Finally… the monkey is off my back, irritating little bugger….