Wednesday, May 9, 2012

Installing SQL Server 2012 Upgrade Advisor

We're hot and heavy into upgrading our BI environment from SQL Server 2008 R2 to 2012 and plan to go live around the middle of next month. To that end, I am in the process of running the SQL Server 2012 Upgrade Advisor on copies of our production servers. Before we can run it, however, we have to get it installed. That turned out to be a little on the obtuse side.


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:
Setup is missing prerequisites: Microsoft SQL Server 2012 Transact-SQL ScriptDom, which is not installed by Microsoft Advisor Setup. To continue, install SQL Server 2012 Transact-SQL ScriptDim from the below hyperlink and then run the Upgrade Advisor Setup operation again: Go to http://go.microsoft.com/fwlink/?LinkID=216742
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):
  1. 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)
  2. 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)
  3. Once you have the .NET Framework and the ScriptDom installed you can install and use the Upgrade Advisor
Happy Upgrading!
Posted by at
Labels: , , ,

7 comments:

  1. AnonymousSeptember 24, 2013 at 9:34 AM

    Thank you, this was very helpful!

    ReplyDelete
  2. AmitApril 9, 2014 at 7:35 AM

    Very Informative Post on MSBI.Good Job

    ReplyDelete
  3. rozeenaApril 9, 2014 at 7:36 AM

    As a faculty i liked ur post.it will be helpful for me also.
    rozeena




    rozeena

    ReplyDelete
  4. AnonymousMay 6, 2014 at 12:40 PM

    Hi Bryant.
    Even 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

    ReplyDelete
    Replies
    1. Bryant ByrdMay 8, 2014 at 7:39 PM

      Hi Mike,

      Did 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

      Delete
  5. MadhuNovember 12, 2014 at 7:37 AM

    It worked for me...
    ScriptDom 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)

    ReplyDelete

Subscribe to: Post Comments (Atom)