Both the cards will be active. For me in my case. I have one ICICI upgraded to Emeralde and the same card I have changed to Rupay also. So I have 3 active cards now with limit shared.
For upgraded on the card will be different and transcations also will be different, whereas in converted both remains same (And I'm not sure whether they will treated it as Dual Card - someone needs to confirm)