I hadn't heard that reverse engineering sql objects was deprecated in Visio 2013!! That kinda sucks for a lot of people I think.

Anyway, I HIGHLY recommend Embarcadero's ERStudio product. I have been using it since the early 2000s. They have an amazing feature set but it is still usable without much hassle if you want the basics. If you are multi-platform they cover pretty much every RDBMS out there. And if you are only SQL Server you can get a very good price for just that platform.