SQL Server数据工具SSDT或SQL Server 2008 R2

Can anyone kindly tell me which one should I install to develop database applications using C#?

任何人都可以告诉我应该安装哪一个使用C#开发数据库应用程序?

SSDT or SQL Server 2008 R2? Or both are the same?

SSDT还是SQL Server 2008 R2?或两者都一样?

2 个解决方案

#1

This two software are two different things, one is a Database Server (SQL Server 2008 R2) the other (SSDT) is a set of tools that expands functionality of Visual Studio to allow the developer to use a lot of feature that are in SSMS directly inside Visual Studio.

这两个软件是两个不同的东西,一个是数据库服务器(SQL Server 2008 R2)另一个(SSDT)是一组扩展Visual Studio功能的工具,允许开发人员直接使用SSMS中的许多功能在Visual Studio中。

So you can install both .

所以你可以同时安装。

#2

It depends which environment you are more comfortable in, Visual Studio or SSMS.

这取决于您更舒适的环境,Visual Studio或SSMS。

But, I recommend SSDT. The main reasons are:

但是,我推荐SSDT。主要原因是:

It is free

这是免费的

You can create your DB application and target multiple SQL Server platforms. And, you get platform-specific validation

您可以创建数据库应用程序并定位多个SQL Server平台。并且,您可以获得特定于平台的验证

SSDT provides Schema Compare

SSDT提供Schema Compare

Integration of DB code with TFS

数据库代码与TFS的集成

Deployment and management of your code changes is so much more easier

部署和管理代码更改变得更加容易

Better code validation engine including Code Analysis

更好的代码验证引擎,包括代码分析

Single integration development environment

单一集成开发环境

Very similar behavior to SSMS

与SSMS非常相似的行为

#1