|
Starting next Friday, they're going to push Windows 10 onto over 5000 systems.
They have FOUR guys that are assigned to "putting out fires as they arise".
The first fire has already come up - VPN no longer works for anyone because they're preparing to update to Windows 10.
After that fiasco has taken hold, they're going to update all of the SQL boxes from 2008R2 to 2012. I don't personally know about the other sql server boxes, but ours has over 500 SSIS packages running. From what I understand, we have to migrate each one of them to be compatible with 2012.
The first description that comes to mind starts with the word "cluster"...
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
And, a great deal of work to be done for which people will be paid.
Is there a path to upgrade SQL 2008R2 to SQL 2012 that will auto-migrate the SSIS packages?
Is there an option to write a 'conversion' utility to upgrade them?
If the nodes are never upgraded, what is the long term outlook? Will the security packages be adequate? Will the application be supported by the vendor?
|
|
|
|
|
As to SSIS, yeah it's not meant to be used on the scale you and I are trying to use it. But ya can't convince management about that.
We went through that and then 2012 to 2014 as well... after cloning nearly everything to a second project first.
If you need to move a bunch of stuff from point A to point B, then a train may be a good idea, a few large trucks may also be a good idea, but trying to use a fleet of sedans is not likely to be the best choice.
|
|
|
|
|
Sounds like vacation time! 
|
|
|
|
|
John Simmons / outlaw programmer wrote: update all of the SQL boxes from 2008R2 to 2012. I don't personally know about the other sql server boxes, but ours has over 500 SSIS packages running.
Each SSIS package needs to be upgraded. I've done this before, no real quick way to do it, it's kind of a PTA.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
BACK UP YOUR DATA FIRST.
I have seen this go horribly wrong for some colleagues. Doubt your scenario is the same as ours was, but it was not pretty. All good now, but painful lessons were learned by some.
-- rants are the vehicle of the lazy and uninspired - JSOP 2/2018
|
|
|
|
|
My plan is to copy the existing data to the new server, and work on it on the new server, leaving the old server up until we're done.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
John Simmons / outlaw programmer wrote: leaving the old server up until we're done.
Not sure if this is going to depend only on you
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
You must be working for the military.
#SupportHeForShe
Government can give you nothing but what it takes from somebody else. A government big enough to give you everything you want is big enough to take everything you've got, including your freedom.-Ezra Taft Benson
You must accept 1 of 2 basic premises: Either we are alone in the universe or we are not alone. Either way, the implications are staggering!-Wernher von Braun
|
|
|
|
|
She'll be right, mate. What could possibly go wrong?
cheers
Chris Maunder
|
|
|
|
|
They are outsourcing the four guys to do the fire fighting, JSOP is predicting a cluster... and PieBALD is betting on a train wreck.
JSOP used to bitch about VB then there was that horrible end user tool he had to train on, we can now look forward to much gnashing of teeth about SSIS upgrading.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
...decided that dragging a window around should minimize all other windows...
You, sir, are a moron.
SET RANT OFF
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
+1
And MDI was better than the way we have it now.
Whoever took MDI away, you sir are a turd burglar.
|
|
|
|
|
|
Don't confuse haters with facts. 
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
It's a stupid feature
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
You must shake a lot!
I never trigger that on regular use.
I'd rather be phishing!
|
|
|
|
|
Agreed. 
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
Or have Parkinsons!
Quote: I never trigger that on regular use.
I never knew it existed!
|
|
|
|
|
glennPattonWork wrote: I never trigger that on regular use.
I've nevver seen that happen, ever!
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Maximilien wrote: You must shake a lot!
He must only shake some...
...because if he shook again then all the windows would come back again.
|
|
|
|
|
|
Well I'll be dammed, a new feature I never knew about and it actually works.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Shake it again and they come back
#SupportHeForShe
Government can give you nothing but what it takes from somebody else. A government big enough to give you everything you want is big enough to take everything you've got, including your freedom.-Ezra Taft Benson
You must accept 1 of 2 basic premises: Either we are alone in the universe or we are not alone. Either way, the implications are staggering!-Wernher von Braun
|
|
|
|
|
Doesn't happen on my system.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
