Microsoft to switch cloud SQL Server from Web APIs to relational one
Changes will give developers more control over manipulating data, ease porting apps to the cloud
Computerworld - Microsoft Corp. said today that its upcoming hosted database service will switch from standard Web programming interfaces to the same relational one used by its on-premise counterpart.
The software maker said it will give developers more control over manipulating data as well as make it easier for them to port existing database applications to the cloud.
SQL Server Data Services (SDS) will connect to database applications via Tabular Data Stream (TDS), the same protocol used by SQL Server, according to a posting at Microsoft's Data Platform Insider blog.
TDS is compatible with Transact-SQL (T-SQL), a proprietary version of the SQL language long used by database developers to write applications for every major database. T-SQL works with SQL Server and Sybase Corp.'s Adaptive Server Enterprise.
The announcement confirmed a report several weeks ago that Microsoft planned to bring "full SQL Server" to its cloud service.
In testing thus far, SDS had connected to applications via general-purpose Web application programming interfaces (API) such as Representational State Transfer and Simple Object Access Protocol. Although they are popular open standards, REST and SOAP are less fine-tuned for pulling and crunching data compared with T-SQL, say the latter's advocates.
Microsoft plans to "decommission" REST and SOAP support, according to the blog. Programmers who are more comfortable with those interfaces, however, can continue to use them by "building custom services with ADO.Net Data Services" or through the table-storage feature of Microsoft's application-hosting platform, Windows Azure, according to the blog.
SDS with TDS support will be available as a public community technical preview by the middle of this year, and it will launched in the second half of the year.
Read more about Databases in Computerworld's Databases Topic Center.
- Silicon Valley's 19 Coolest Places to Work
- Is Windows 8 Development Worth the Trouble?
- 8 Books Every IT Leader Should Read This Year
- 10 Hot Hadoop Startups to Watch
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- ERP in the Cloud and the Modern Business View IDC's White Paper, to review IDC CloudTrack Survey findings, gain expert insight into the challenges and opportunities the cloud presents, and determine...
- Oracle ERP Cloud Service - Back-Office Solutions that Keep You in Front Learn how you can harness the power of the cloud to run your business more effectively and lower upfront costs.
- Integration with Oracle Fusion Financials Cloud Service While moving your financial system to the cloud may seem straightforward, truly realizing the advantages of the cloud requires a complete understanding how...
- Hadoop for Dummies Today, organizations in every industry are being showered with imposing quantities of new information. Along with traditional sources, many more data channels and...
- Live Webcast Best Practices: How to Improve Business Continuity with Virtualization VMware solutions include a range of business continuity capabilities to help ensure availability for applications across your virtualized environment. Learn More>>
- Cloud Knowledge Vault Learn how your organization can benefit from the scalability, flexibility, and performance that the cloud offers through the short videos and other resources...
- Endpoint Data Management: Protecting the Perimeter of the Internet of Things Not surprisingly, "Internet of Things" (IoT) and Big Data present new challenges AND opportunities for enterprise IT. Teams need to harness, secure and... All Data Center White Papers | Webcasts