-
Book Overview & Buying
-
Table Of Contents
Microsoft SQL Azure Enterprise Application Development
By :
This chapter described in detail how SSIS and SSRS are used in creating BI projects using SQL Azure data. Using some of the tools described in the previous chapter, a table on the on-site server was partitioned to keep sensitive data on the site and non-sensitive data on SQL Azure. A SSIS package was created to merge data from an on-site location and SQL Azure for internal reporting. A second SSIS project showed how easy it is to migrate data from a MySQL database to SQL Azure. Two reporting services projects were described in this chapter: one using BIDS and the other using Report Builder 3.0, to author a report using data on SQL Azure.
Chapter 7, Working with Windows Azure Hosting lays the basis for the following chapter where details of how web facing projects deployed to Windows Azure Cloud access relational data.
Change the font size
Change margin width
Change background colour