July 2014 Update to SQL Server Data Tools

Latest release of SQL Server Data Tools(SSDT) is now available here:

http://msdn.microsoft.com/en-us/data/hh297027

This update is now available for Visual Studio 2012 and 2013

Instead of the above link you can also get it from inside Visual Stuido 2012 via Tools -> Extensions and Updates->Updates.

What's new in this:
Of course more bug fixes and some of the following enhancements:

• Schema Compare update

         Added MSBuild support for Schema Compare with text and XML output.  A blog post is    available with more information.

• Improved Windows Azure SQL Database node in the Server Explorer

        Added Token-based authentication using a Microsoft account (MSA) or organizational account (OrgId)

        Added supported for VS2012

• Improved (Parallel Data Warehouse) PDW support

       PDW tooling is now part of the Microsoft Visual Studio Express 2013 for Windows Desktop SKU.  This requires the VS 2013 Update 2 or later to be installed

      Support for PDW appliance updates in both VS2012 and VS2013

Also read:
http://brianwmitchell.com/2013/11/sql-server-to-pdw-migration-whitepaper/

SSDT for SQL Server 2014 here:
http://hodentek.blogspot.com/2014/03/sql-server-data-tools-to-go-with-sql.html

SSDT BI_Templates here:
http://hodentek.blogspot.com/2013/10/ssdt-bi-templates-for-sql-server-2012.html

SSDT Web Site:
http://msdn.microsoft.com/en-us/data/tools.aspx

Moving from SQL Server 2012 to SQL Server 2014

SQL Server 2014 is still in CTP2 and SQL Server 2012 has been around for some time. You could get a SQL Server 2012 Express free of cost but with limited functionality.

You can download SQL Server 2014 CTP2 here:
http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx

While on the above make sure you read all the good things you can do with SQL Server 2014.

You may want to know what you can do with SQL Server 2014 CTP1 that you cannot do with SQL Server 2012 Express. If you are looking at just the tasks that you can accomplish, then compare the two images below (the limited number of tasks is that of SQL Server 2012 Express).

SQL Server 2012 Express

SQL Server 2014 CTP1 (enterprise)

 

Quite a lot of the tasks are new features such as Managing Database Encryption, Deploying to Windows Azure VM, etc.

 

SSDT for SQL Server 2014 CTP2

You will get SQL Server 2014 CTP2 Data Tools BI Project templates if you install Microsoft SQL Server 2014 Data Tools BI for Microsoft Visual Studio 2012, CTP2. Note that this does not work with Microsoft SQL Server 2012. It is supported only on x64 architecture of Windows Servers 2208 R2 and 2012 but on both X32 and X64 for Windows 7 and Windows 8.

Download link here
http://www.microsoft.com/en-us/download/details.aspx?id=40736

This is the file that is installed and is strictly to support CTP2 only:
SSDTBI_VS2012_x86_ENU.exe(537.1 MB), Version:12.0.15240 Published date:10/14/2013

This installs the Microsoft SQL Server 2014 CTP2 Data Tools Business Intelligence project templates for Analysis Services, Integration Services, and Reporting Services.

Make sure you have these on the computer as prerequisites:
•Microsoft .NET Framework 4.5
•Microsoft Visual Studio 2012 Shell (Isolated) Redistributable Package
•Microsoft Visual Studio 2012 Shell (Integrated) Redistributable Package
•Microsoft Visual Studio Tools for Applications 2012
•Microsoft Report Viewer 2012 Runtime

Details of December 2012 update here.

SSDT 2012 news here.

 

SQL Server 2014 CTP2 is out, get it fast.

It is available for immediate download.

Don't click on the start to get evaluation! It won't take you to SQL Server 2014 CTP2.

Access the main link here:
http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx

New capabilities :
Promises new in-memory capabilities
Promises new cloud capabilities

Here is a cutout from product documentation.

Want to check it out, download from here:
http://www.microsoft.com/en-us/download/details.aspx?id=39269
The installation should follow the same steps as in installing SQL Server 2014 CTP1.

Get full screen shots here.
http://hodentekmsss.blogspot.com/2013/09/installing-sql-server-2014-ctp1-on.html

Complete product guide here:
http://www.microsoft.com/en-us/download/details.aspx?id=39269

Mahalo,
Jay