Exporting a Data-tier application from SQL Server using SSMS has a problem

According to MSDN (https://msdn.microsoft.com/en-us/library/hh213241.aspx)  it is quite simple to Export a data-tier application. Here is an overview of exporting a database as a Data-tier .bacpac file which can be deployed to another server.

"Exporting a deployed data-tier application (DAC) or database creates an export file that includes both the definitions of the objects in the database and all of the data contained in the tables. The export file can then be imported to another instance of the Database Engine, or to Azure SQL Database. The export-import operations can be combined to migrate a DAC between instances, to create an archive, or to create an on-premise copy of a database deployed in SQL Database.
"
The steps are very clear as the Export data-tier application task brings up a wizard and you just have to follow the steps.
The following screen shots show the process for exporting from a SQL Server 2012 instance.

Initiating the Export Data-Tier Wizard. Click Export Data-tier Application...

Wizard shows up.

Click Next.

In the above you can save it to a local disk (Folder/File) or save to Microsoft Azure. Here the default is accepted.

The Next is greyed as there was an earlier file. However the database had changes and a new one was created with a different name.

Data in the tables will also be exported.

Click Finish. The Wizard starts processing.

The result of processing is that the operation did not succeed.

The reason is in the error shown below.

Looks like some implied incompatibility with some Microsoft Azure SQL database. It may be noted that the target file was supposed to be saved to the local disk and not Microsoft Azure.

This happens in SQL Server 2014 as well.

According to a recent MSDN forum post, the failure in SQL Server 2012 and SQL Server 2014 for this particular case of Northwind database is perhaps related its

Read these popular blog posts related to data-tier applications:
http://hodentekmsss.blogspot.com/2010/07/sql-server-2008-r2-and-data-tier.html
http://hodentekmsss.blogspot.com/2013/12/deploying-dac-to-sql-server-2014.html

SQL Server Driver for PHP released

SQL Server driver (SQLServer31.exe, 499KB, version 3.1.CTP) for PHP is now available as a CTP. Now PHP scripts can access Microsoft SQL Server and Microsoft Azure SQL Database.

You can download the CTP here:
http://www.microsoft.com/en-us/download/details.aspx?id=20098&WT.mc_id=Blog_SQL_Announce_DI

Details of this version:

• This version supports PHP Version 5.5 and requires Microsoft ODBC driver 11 (or higher)
• It supports SQL Server 2012; localDB abd AlwaysOn features
• Buffered Queries are included

All SQL Server user can get it at no extra cost.

This widens the interoperability range.
The soon to be released JDBC driver compatible with JDK7 for SQL Server will enable applications to connect to SQL Server widening connectivity with the Java Platform.

Three more Microsoft Azure Datacenters operating now

Do not forget to get free books on Microsoft Windows Azure.

Azure Datacenter is now generally available in Brazil. A promotional pricing is offered right now. Geo replication to South US datacenter from Brazil dictates default storage option being Geographically Redundant Storage.

Brazil Datacenter debuts after two other data centers in Asia:
http://windowsitpro.com/azure/microsoft-opens-azure-datacenter-brazil-south-region

Japan GEO
 http://azure.microsoft.com/ja-jp/community/japan-datacenter-geo/

China operated by 21Vianet
 http://www.datacenterdynamics.com/focus/archive/2014/03/microsoft-launches-mainland-china-azure-cloud-data-center


This is what you should do to get your free book. Note only the first three persons (from Brazil, Japan and China) to respond will get the book.

Send an email to hodentek@live.com with Azure SQL in the subject line. Include your email address and your postal address to get a free copy of my book on Windows Azure SQL Database.
http://hodentekmsss.blogspot.com/2010/12/regarding-my-book-on-sql-azure.html

 

Microsoft / SAP Alliance & SQL Server

Your employees can now dig deeper to get value out of your business and the Microsoft / SAP alliance makes it lot more flexible, lot easier and more enriching. Now, this alliance makes it possible to have integrated solutions  meshing up these two technologies making the any where, anytime information critical to business available without much effort.

Microsoft / SAP Alliance has many other facets in addition to Microsoft SQL Server and Microsoft BI. Review this link here:
http://hodentek.blogspot.com/2014/05/microsoft-sap-alliance-enriching-cloud.html

This alliance covers all of MSFT, cloud, mobile, office, BI, etc.

Microsoft SQL Server 2012 is the best suited database for mission-critical environment. It offers the lowest total cost of ownership(TCO) for all of SAP's needs. Probably the recently released SQL Server 2014 will follow in due course.

These cost savings come through,

• Increased flexibility
• High database productivity
• Increased hardware utilization,
• Minimized surface area against attacks, etc.

Follow this link for more details regarding SAP and SQL Server:
http://scn.sap.com/community/sqlserver

Review these important SAP notes on SQL Server:
http://scn.sap.com/docs/DOC-8286