Introducing Windows Azure- P53:The cloud platform is getting more and more attractive to the computing world. Today, service-oriented architecture (SOA) and aspect-oriented programming (AOP) techniques are widely used in enterprise solutions. A question an IT management team or a software development team may ask is, what is the next trend going to be? Cloud computing seems to be the right answer. | CHAPTER 8 SQL AZURE 4. Click Next. SQL Server Management Studio will generate the scripts in a new SQL script edit window. Figure 8-14 shows a successful generation. Figure 8-14. The scripts were successfully generated 5. Log in to the Azure platform portal at https and create a database AzureForDotNetDeveloper from SQL Azure in the cloud recall that the screenshot shown in Figure 8-3 shows the created database . 6. Copy the previously generated script to the clipboard or save it into a file. Close SQL Server Management Studio and reopen it by following the steps shown in Figure 8-4 to establish a connection to the AzureForDotNetDeveloper database in the cloud. 7. If you run the generated script without any modification then you will get an error message as Listing 8-8 shows. Listing 8-8. Error Message from Running Scripts Generated by SQL Server Management Studio Against SQL Azure Without Modification Msg 195 Level 15 State 5 Line 2 ANSI NULLS is not a recognized SET option. Msg 40512 Level 16 State 1 Procedure InsertInstanceState Line 3 Deprecated feature Data types text ntext or image is not supported in this version of SQL Server. Msg 195 Level 15 State 5 Line 2 258 CHAPTER 8 SQL AZURE ANSI NULLS is not a recognized SET option. Msg 40512 Level 16 State 1 Procedure InsertCompletedScope Line 5 Deprecated feature Data types text ntext or image is not supported in this version of SQL Server. Msg 195 Level 15 State 5 Line 2 ANSI NULLS is not a recognized SET option. Msg 195 Level 15 State 5 Line 2 ANSI NULLS is not a recognized SET option. Msg 40517 Level 16 State 1 Line 16 Option pad index is not supported in this version of SQL Server. 8. Modify the output script as follows. a. Delete all SET ANSI NULLS ON GO b. Delete all PAD INDEX OFF c. Delete all ALLOW ROW LOCKS ON ALLOW PAGE LOCKS ON d. And replace it with the following ALLOW ROW LOCKS OFF ALLOW PAGE LOCKS OFF e. Delete SORT IN TEMPDB OFF f. The first release of SQL Azure does not .
