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 connection to SQL Server Compact from Microsoft SQL Server 2011

There appears to be no way to connect to SQL Server Compact using the SSMS installed with SQL Server 2011 (Denali). There is however a menu item that indicates that one should be able to connect but it stops there. This menu item when chosen does not provide a SQL Compact Editor icon which used to be available in earlier versions.












The !sorry Mozilla you could not show this (Firefox Version 3.6.13.)!  button (the last item in the drop-down list) in the 'Connect to Server' window used to have an opening to the file system to find the SQL Server Compact files if there were any. But this not possible as you can only browse for servers and not files in the new SSMS.