CODEWITHSUNDEEP
sql-serversql-server-2008-r2sql-server-2012ssms
Farhan
Farhan

Reputation: 2575

SQL Server 2012 SSMS with SQL Server 2008 R2 database engine

I use SQL Server 2008 R2 as the database engine. With my MSDN subscription, I can get SQL Server 2012 for development use. Since I noticed some cool things in 2012 SSMS, my question is that if I only use 2012 SSMS and keep 2008 R2 as the database engine, will there be any difference in scripts' generation or any other effects?

Thanks.

UPDATE 1: Oh yes, I saw this page: SQL Server Database Engine Backward Compatibility, but it is not exactly what I am looking for.

Upvotes: 0

Views: 1690

Answers (1)

Russ Davis
Russ Davis

Reputation: 66

No, there should be no ill effects.

SSMS 2012 should generate scripts that are compatible with the database version that is being actively used.

Upvotes: 5

Related Questions