SQLServer/SQLServerのバージョン関連 - tak_ism

2016-12-16 16:38:41 (Fri);

プロダクトのバージョンと製品

SELECT SERVERPROPERTY('productversion')
SELECT @@VERSION

productversion	製品名
13.0.1601.5	SQL Server 2016
12.0.4100.1	SQL Server 2014 SP1
12.0.2000.8	SQL Server 2014
11.0.3000.0	SQL Server 2012 SP1
11.0.2100.60	SQL Server 2012
10.0.1600.22	SQL Server 2008
10.0.2531.00	SQL Server 2008 Service Pack 1
10.50.1600.1	SQL Server 2008 R2
9.00.1399.06	SQL Server 2005
9.00.2047.00	SQL Server 2005 Service Pack 1
9.00.3042.00	SQL Server 2005 Service Pack 2
9.00.4035.00	SQL Server 2005 Service Pack 3
8.00.194	SQL Server 2000
8.00.384	SQL Server 2000 SP1
8.00.534	SQL Server 2000 SP2
8.00.760	SQL Server 2000 SP3
8.00.760	SQL Server 2000 SP3a
8.00.2039	SQL Server 2000 SP4
7.00.623	SQL Server 7.0
7.00.699	SQL Server 7.0 Service Pack 1 (SP1)
7.00.842	SQL Server 7.0 Service Pack 2 (SP2)
7.00.961	SQL Server 7.0 Service Pack 3 (SP3)
7.00.1063	SQL Server 7.0 Service Pack 4 (SP4)
6.50.201	SQL Server 6.5
6.50.213	SQL Server 6.5 Service Pack 1 (SP1)
6.50.240	SQL Server 6.5 Service Pack 2 (SP2)
6.50.258	SQL Server 6.5 Service Pack 3 (SP3)
6.50.281	SQL Server 6.5 Service Pack 4 (SP4)
6.50.415	SQL Server 6.5 Service Pack 5 (SP5)
6.50.416	SQL Server 6.5 Service Pack 5a (SP5a)
6.50.479	SQL Server 6.5 Service Pack 5a (SP5a) Update

互換性レベルの確認

SELECT compatibility_level,* FROM sys.databases 

memo
ttp://blog.engineer-memo.com/2014/12/14/sql-server-%E3%81%AE%E3%83%90%E3%83%83%E3%82%AF%E3%82%A2%E3%83%83%E3%83%97%E3%81%AE%E3%83%AA%E3%82%B9%E3%83%88%E3%82%A2%E3%81%A8%E4%BA%92%E6%8F%9B%E6%80%A7%E3%83%AC%E3%83%99%E3%83%AB%E3%81%AE%E6%95%B4/

ttps://kazu.tv/blog/2016/06/16/migrating-sql-server-2000-to-2014/

ttp://blog.engineer-memo.com/2015/07/27/%E4%BA%92%E6%8F%9B%E6%80%A7%E3%83%AC%E3%83%99%E3%83%AB-80-%E3%81%AE-sql-server-2005-%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E3%81%AB%E5%AF%BE%E3%81%97%E3%81%A6%E3%82%A2/

---