Une question que l'on voit émerger est de savoir lequel de ces deux services on doit utiliser lorsque l'on veut développer une application dans les nuages ?
Et bien, en première approximation, on peut comparer le service SDS à une base de données dans les nuages, alors que WAS correspond de près ou de loin à notre système de fichiers en local.
Donc si votre application a des besoins simples de stockage WAS devrait suffire. Par contre, si l'on veut aller au-delà et manipuler les données de manière complexe alors SDS est la solution vers laquelle il faut regarder.
Il est vrai qu'aujourd'hui les différences de fonctionnalités entre les deux produits ne sont pas très importantes : en fait la seule différence notable est l'équi-jointure qui est disponible avec SDS (et ne l'ai pas avec WAS).
Mais à l'avenir les différences devraient être plus marquées puisque l'on retrouvera autour de SDS tout l'écosystème que l'on a autour de SQL Server comme par exemple :
SQL Server Reporting Services à partir de données SDS ou
recense tous les projets autour de SDS et qui indique quels pourront être les évolutions futures du service :
Data Mining in the Cloud- The SQL Server Data Mining team is working to extend the power and ease of use of SQL Server Data Mining to the Cloud. Our goal is provide services that allow you to build rich, predictive applications without worrying about server infrastructure, and showcase these services with cool applications that give you a glimpse of what’s possible
U Rank– This Microsoft Research project is exploring how personalization, social context, and communication may be used to improve the search experience and leveraging SQL Data Services to power the service. Use the search engine to re-rank search results, move results from one search to another, add notes, and otherwise edit searches. Not only will you see your changes again the next time you come back, but your friends will see the changes too!
Project Codename "Anchorage"– We’re evolving the popular SyncToy application to enable much more than just file/folder synchronization between PCs, devices, and services! With this project, providers will be able to register and be discovered in a variety of sync groups including contacts, files, favorites, videos, as well as photos across endpoints such as the Live Mesh, PhotoBucket.com, Smugmug.com, and more
Project Codename “Huron”- Leverage the power of SQL Data Services to enable enterprise edge scenarios using the technologies in this incubation! Share data with relational stores like Access, SQL Express, SQL CE, SQL Server, enable B2B data sharing, and push workgroup databases to field workers and mobile users
Reporting against SQL Data Services– Leverage SQL Server Reporting Services (SSRS) 2008 to build and deploy rich reports against data hosted in SQL Data Services (SDS). SSRS data source extensibility framework is used to provide an incubation custom data extension for SDS. Developers can download the custom extension and configure it against their on-premise SSRS 2008 installation. This will allow them to connect to SDS authorities and containers via HTTP SOAP to extract data sets, build rich reports using standard tools like Report Designer / Report Builder and deploy the reports to Report Manager
Codename “Astoria” Offline- Version 1 of ADO.NET Data Services Framework (a.k.a. Project "Astoria") introduced a way of creating and consuming flexible, data-centric REST services. Now we are working on creating an end-to-end story for taking data services offline using synchronization. Integrating data services with the Microsoft Sync Framework will enable developers to create offline-capable applications that have a local replica of their data, synchronize that replica with an online data service when a network connection becomes available, and use replicas with the ADO.NET Entity Framework for regular data access.
Accessing SDS using ADO.NET Data Services- This incubation project focuses on aligning SDS and ADO.NET Data Services. With this alignment SDS will support AtomPub and JSON formats. It will also provide support for established set of conventions for constructing URLs to point to resources. We are also extending ADO.NET Data Services to provide access to the flexible data stored in SDS.
Data Mining in the Cloud - The SQL Server Data Mining team is working to extend the power and ease of use of SQL Server Data Mining to the Cloud. Our goal is provide services that allow you to build rich, predictive applications without worrying about server infrastructure, and showcase these services with cool applications that give you a glimpse of what’s possible