Database Reference
In-Depth Information
•
What type of design will create more or fewer issues? For example, should you use
GUIDs versus INTs for record identifiers?
How can you use data synchronization in a data warehouse environment? For
example, with geographically placed data centers, it may be beneficial to sync
region-specific data.
The answers to these questions will certainly change between now and release to public, and even
past release as SQL Azure Data Sync is put to use. They will also differ depending on the environment.
These questions are meant to give you some guidance about what to consider when you're looking at
using SQL Azure Data Sync in your environment.
•
Conclusion
Although the SQL Azure Data Sync Service is yet to be officially released, this chapter provided a detailed
walkthrough of the functionality you can expect to see when it's released. You learned how to set up a
sync, and the different options you have for syncing your data. You also now have several items to think
about as you plan your synchronization.
In Chapter 12 we discuss SQL Azure performance tuning, discussing topics such as Sharding which
are aimed at ensuring that your Azure experience is a successful.
