Finding the installer was pretty easy, it's right in the SQL Server Installation Center:
If you're not prepared, however, you'll get the following error message when you try to use the installer:
That link doesn't work and isn't even clickable! Not only that, but finding the installer you need may not completely solve the problem.
To make a long blog post a little bit shorter, here's what you need before you can install the SQL Server 2012 Upgrade Advisor (in order):
- Microsoft .NET Framework 4.0 (I recommend the full installer and not the web-based thing. Download it from http://www.microsoft.com/en-us/download/details.aspx?id=17718)
- SQL Server 2012 Transact-SQL ScriptDom (Go to the Microsoft® SQL Server® 2012 Feature Pack page and you'll find it about 3/4 of the way down the page)
- Once you have the .NET Framework and the ScriptDom installed you can install and use the Upgrade Advisor
Thank you, this was very helpful!
ReplyDeleteVery Informative Post on MSBI.Good Job
ReplyDeleteAs a faculty i liked ur post.it will be helpful for me also.
ReplyDeleterozeena
rozeena
Hi Bryant.
ReplyDeleteEven after doing the suggestions, I still received the ScriptDom not installed error window. The same installation programs run fine on a Windows 7 box, the Advisor even runs. But on a Sql Server 2008 box, the ScriptDom error is displayed?
Mike
Hi Mike,
DeleteDid you install the right "bitness" (32 or 64) for your server? It's been a while since I ran into this and I don't remember if it's supposed to match the server or whatever client tools your trying to use. I don't remember if a reboot was required either.
I'm sorry that I don't have more help to give you. I thought it had been a long time since I posted this and when I looked the top I realized that it will be two years tomorrow since the original post. If you figure it out, please post a comment or link to the solution in case someone else runs into the same issue.
Thanks for stopping by!
Bryant
It worked for me...
ReplyDeleteScriptDom will be located at
MICROSOFT SQL SERVER 2012 ENGINE FEATURE PACK COMPONENTS
Microsoft® SQL Server® 2012 Transact-SQL ScriptDom
Microsoft SQL Server Transact-SQL ScriptDom is a .NET Framework API that provides parsing and scripting services for Transact-SQL. This API supports SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 versions.
X86 Package(SQLDOM.MSI)
X64 Package (SQLDOM.MSI)
Thanks for the extra information Madhu!
Delete