I’m sure you’ve heard of the “cloud” recently. There are lots of “cloud services” that are popping up in and around SQL Azure so I’d like to take a moment to put a few things into perspective.
Here’s a quick summary for each:
- A database engine platform as a service
SQL Azure Data Sync
- A service which will synchronize data between database engines
SQL Azure Import/Export (New – see the next post!)
- A service that will load data directly between a SQL Azure database and Windows Azure BLOB storage
So to rationalize in a nutshell, SQL Azure is the core database and there are other services which provide additional value and capabilities. The Data Sync service is designed to replicate data between different SQL databases whereas the import/export service is designed specifically for data loading scenarios to and from a file format.