SQLTeam.com | Weblogs | Forums

How to tell the difference between two SQL server 2012 sources


#1

Hi,

I am installing SQL Server 2012 Enterprise into a group of servers. And I just noticed I accidentally started from two different source locations. I couldn't figure out if they are the same.

SW_DVD9_SQL_Svr_Enterprise_Edtn_2012_English_MLF_X17-96957 in a folder last modified=1/7/2013, and the setup app dated 2/12/2012
and,
SW_DVD9_SQL_Svr_Ent_Core_2012_English_MLF_X17-99682.IMG date:12/19/2013 and setup app dated 2/11/2013

After I installed SP2 on top of them, in SSMS they all read SQL Server 11.0.5058.

Are they identical?

These servers will be on the same AlwaysOn Failover Cluster group with the underlying WSFC.

If it is all possible, I don't want to spend time going back uninstall then start over from the same source.

Your expertise is highly appreciated!

H


#2

As far as I understand that you want to compare the both SQL Server instances. The SSDT includes a Schema Compare utility that you can use to compare two database definitions. To know more please move on this article https://msdn.microsoft.com/en-us/library/hh272690(v=vs.103).aspx