January 7, 2015 at 12:33 pm
I was trying to find a download for SQL Server 2014 Upgrade Advisor to be run on a SQL Server 2014 instance.
I run the installer (ENU\x86\SqlUA.msi) and it tells me that I have to run the prerequisites. I click the link and it redirects me back to the same download feature pack.
Where are the files to download and which order do they get executed in?
Thank you.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 7, 2015 at 2:07 pm
You can view the prerequisites here: http://msdn.microsoft.com/en-us/library/ee240731.aspx
Windows Installer 4.5
.NET 4
Microsoft SQL Server Transact-SQL ScriptDom (part of the SQL Server 2014 feature pack which is probably why it keeps taking you back to that site)
January 7, 2015 at 2:31 pm
Thanks.
I just found that it is in the planning link of the installation media.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 7, 2015 at 3:49 pm
Maybe it's a typo, but why would you run the SQL Server 2014 Upgrade Advisor against a SQL Server 2014 instance? Isn't it already on SQL Server 2014?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 7, 2015 at 4:23 pm
Yeah,
I went to several websites and I did not find the correct files to download.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 7, 2015 at 4:44 pm
Should I use the 2008 upgrade advisor or what?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 7, 2015 at 6:57 pm
Welsh Corgi (1/7/2015)
Should I use the 2008 upgrade advisor or what?
I don't understand what you're trying to do.
Your first post said:
SQL Server 2014 Upgrade Advisor to be run on a SQL Server 2014 instance
And I'm trying to figure out why you need to run a 2014 advisor against an instance that is already on 2014. That just doesn't make sense.
If you have an older version of SQL Server and you want to run the 2014 Upgrade Advisor, here's the page that includes the downloads and the install instructions.
But, I'm not sure what will happen if you run against a 2014 instance. It won't break or anything, but I suspect it'll just say it can't find anything to upgrade.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 8, 2015 at 1:08 am
Sorry :blush: I'm upgrading from SQL Server R2 to SQL Server 2014.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 8, 2015 at 4:04 am
OK. Not a problem. The link I provided should do what you need then.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 8, 2015 at 6:28 am
ok, thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply