A workaround for restoring HierarchyId in SQL server 2014
I am looking for a workaround.


For me, based on conversations I've seen about this elsewhere, you have four options:


Perform a system restore to a point prior to the Visual Studio CTP installation. 
Wait for Connect item #1063935 to be addressed - it may be in a future Cumulative Update or Service Pack for SQL Server, or it may be in a patch or some kind of update for the Visual Studio preview. It is not addressed explicitly in Cumulative Update #6, but applying that can't hurt to try.
Back up your databases somewhere, and remove everything Visual Studio, .net &amp; SQL Server related (the hard way, not through the Control Panel), and install SQL Server again.
If 3. doesn't work, back up your databases somewhere, and nuke &amp; pave your OS.


If 1. is not possible, then you need to take further action in the future to prevent having to do these other much harder things:


Either don't install Visual Studio, SQL Server etc. CTP or preview versions on your critical / primary workstation (virtual machines are a much better target for this sort of thing); or,
start taking better system backups so that if you do decide to install such things you can recover.


This can be an expensive lesson that, sadly, most people learn the hard way.