Tuesday, September 13, 2011

SQL Server Database Project with SSDT

SQL Server Developer Tool also known as SSDT is a new Microsofft Tool debuting with Denali which is in CTP3. You need to install 'Juneau' to take advantage of this tool in Visual Studio. My previous post did not use the SQL Server Database project which was targeting DENALI but only previous versions. LocalDB is a feature of Denali which is to SQL Server as Cassini (the localhost in Visual Studio web applications) is to IIS.
Visual Studio 2010 does support LocalDB provided the new SQL Server Developer Tool (SSDT) is installed. After installing SSDT you need to create a SQL Server Database project as shown.



The SQL Server Database that is used within the project is the LocalDB. Here you can call up the table designer using Add Table as shown.

No comments:

Post a Comment

Is Vector Search in SQL Server 2025 the Key to Unlocking New Data Insights?

 The advent of AI has ushered in ground breaking changes in most areas of technology. AI is synonymous with a humongous amount of data, data...