SQl server 2012 管理程序 连 SQl server 2016 实例,可以成功,这样可以吗?

%3CLINGO-SUB%20id%3D%22lingo-sub-2055760%22%20slang%3D%22zh-CN%22%3ECan%20the%20SQl%20server%202012%20manager%20succeed%20even%20with%20the%20SQl%20server%202016%20instance%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2055760%22%20slang%3D%22zh-CN%22%3E%3CP%3ECan%20the%20SQl%20server%202012%20manager%20succeed%20even%20with%20the%20SQl%20server%202016%20instance%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWill%20there%20be%20any%20additional%20problems%20connecting%20and%20operating%20like%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2059614%22%20slang%3D%22en-US%22%3ERe%3A%20SQl%20server%202012%20%E7%AE%A1%E7%90%86%E7%A8%8B%E5%BA%8F%20%E8%BF%9E%20SQl%20server%202016%20%E5%AE%9E%E4%BE%8B%EF%BC%8C%E5%8F%AF%E4%BB%A5%E6%88%90%E5%8A%9F%EF%BC%8C%E8%BF%99%E6%A0%B7%E5%8F%AF%E4%BB%A5%E5%90%97%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2059614%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F927233%22%20target%3D%22_blank%22%3E%40billpeace%3C%2FA%3E%2C%20If%20you%20mean%20to%20manage%20a%20newer%20SQL%20Server%20version%20with%20a%20older%20SSMS%20(Management%20Studio)%2C%20yes%2C%20that's%20possible%2C%20but%20newly%20introduced%20features%20will%20be%20missing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20always%20the%20best%20option%20to%20use%20the%20latest%20SSMS%20version%2C%20you%20can%20download%20it%20here%3A%3C%2FP%3E%3CP%3E%3CFONT%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fssms%2Fdownload-sql-server-management-studio-ssms%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fssms%2Fdownload-sql-server-management-studio-ssms%3Fview%3Dsql-server-ver15%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

SQl server 2012 管理程序 连 SQl server 2016 实例,可以成功,这样可以吗?

 

这样连接,进行操作,会有啥 额外问题吗?

1 Reply

@billpeace, If you mean to manage a newer SQL Server version with a older SSMS (Management Studio), yes, that's possible, but newly introduced features will be missing.

 

It's always the best option to use the latest SSMS version, you can download it here:

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server...