Benjamin Guinebertière

Do I have VM Roles that I should migrate?

Benjamin GUINEBERTIERE — Fri, 19 Apr 2013 11:41:53 GMT

You may have received this kind of e-mail and wonder if you have already VM Roles deployed. There are good chances the answer is no, but let’s check.

Dear Customer,

The Windows Azure VM Role preview is being retired on May 15. Please transition to Windows Azure Virtual Machines, and delete your VM Role preview instances as soon as possible.
Thank you for participating in the preview program for the Windows Azure VM Role. Since we started the preview program, we have learned a lot about your needs and use cases. Your feedback and insights have helped fine-tune our approach to infrastructure services. We’ve directed all of that feedback into the design of Windows Azure Virtual Machines, the evolution of VM Role.
On April 16, 2013, we announced the general availability of Windows Azure Virtual Machines. Virtual Machines provides on-demand scalable compute resources to meet your growing business needs and can extend your existing infrastructure and apps into the cloud. With the general availability of Windows Azure Virtual Machines we are retiring the VM Role preview.
ACTION REQUIRED
Please migrate from VM Role to Virtual Machines, and delete your running instances of VM Role as soon as possible. You can these follow these instructions to migrate to Virtual Machines.
Here are important dates to note:

• Starting May 15, 2013, calls to create new VM Role deployments will fail.

• On May 31, 2013, all running VM Role instances will be deleted.

Please note that you will continue to be billed for your VM Role consumption until your running instances are deleted.
Thank you for participating in the VM Role preview program and shaping the future of Windows Azure Virtual machines! You can find more information on Windows Azure Virtual Machines here.
Thank you,
Windows Azure Team

A simple way to check whether you have VM Roles or not is to use the previous portal (the one in Silverlight) which is available at https://windows.azure.com/. From the new portal (https://manage.windowsazure.com) you can choose previous portal in the menu.

From the main page, click on Hosted Services, Storage Accounts & CDN

and VM Images

If you have a VM Role image, this looks like this

In my case, it is not instanciated as In use is False (I haven’t used VM Roles for years, I think; this image was created in March 2011!), and I don’t have anything to do.

More information is also available at http://msdn.microsoft.com/en-us/library/gg465398.aspx.

Benjamin Guinebertière (@benjguin)

How to install Hadoop on Windows Azure Linux virtual machines

Benjamin GUINEBERTIERE — Fri, 05 Apr 2013 15:58:13 GMT

Windows Azure HDInsight is the simplest option to get a Hadoop cluster up and running very quickly in a Windows Azure environment. Among other numerous advantages, this service allows to use Windows Azure blob storage (ASV or Azure Storage Vault for short) exactly as HDFS (Hadoop distributed file system). In its public beta version, Windows Azure HDInsight uses ASV as its default file system. I put some screen shots of what you can easily do (in a matter of minutes) with such a cluster in this post: TUTO - Hadoop arrive dans le portail Windows Azure. Lançons des jobs Java, PIG et HIVE pour voir !.

Still, you may want to install a custom distribution, run custom components which are not available in the HDInsight distribution, or have Hadoop running on Linux instead of Windows. This post shows how to install a Linux distribution on Windows Azure virtual machines.

While it is possible to install several distributions like MapR, CDH (Cloudera) or HortonWorks (HDP) on different Linux OSs like CentOS, SUSE, or Ubuntu, this post takes HDP 1.2 on CentOS as an example. The documentation I want to be able to follow here in order to install the cluster is the Hortonworks’ HDP 1.2.2 installation with Ambari on CentOS.

In this post, I suppose you already have a Windows Azure account. The windowsazure.com web site can provide you with the information you need to get one. I also suppose readers are quite advanced users so I don’t give all the details when documentation also exists elsewhere.

Scope

This blog post shows one way to install a Linux Hadoop cluster. It may not respect all the best practices, particularly in terms of security. The goal of the post is to show how this kind of environment can be hosted in Windows Azure. In this post, I chose to use Windows (DNS Server, Web Browser, scripting environment, …) because this is what is simple for me, but this is possible to install the cluster without using Windows at all. I give some hints on how to do that. Also, I use the portal and PowerShell (scripting) because I find it more easy to understand that way, but I’m pretty confident everything could be done with scripting.

Choosing the Windows Azure environment for the Linux cluster

There are several ways to have a local network in Windows Azure. One of them is to create a virtual network.

I also want to be able to use a browser against the cluster and have a DNS I can easily setup and manage. In this scenario, I install a Windows Server which plays those roles. This is because I’m more a Windows guy ! Note that you may prefer installing a Linux based DNS server in the virtual Network and browse the cluster thru an SSH tunnel.

The following table contains the machines I want to instanciate and their roles:

Server Name	Server role	subnet
n124dns	DNS Browser (Windows Server)	subnet1
n124m	master node	subnet2
n124w1 to n124w3	worker nodes	subnet3

In this sample, all machines are in the following DNS domain name : n124.benjguin.com

At the end, I’ll have those machines:

n124dns will be a Windows Server machine, and it could be a Linux machine.

All other will be Linux machines.

Configure the Virtual Network

You can find details on Windows Azure virtual networks here: http://www.windowsazure.com/en-us/manage/services/networking/.

I create a virtual network like explained at http://www.windowsazure.com/en-us/manage/services/networking/create-a-virtual-network/.

The parameters I enter are detailed in the XML file below (this file can be obtained by exporting the virtual network configuration from the Windows Azure Management portal).

<NetworkConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/ServiceHosting/2011/07/NetworkConfiguration">
  <VirtualNetworkConfiguration>
    <Dns>
      <DnsServers>
        <DnsServer name="n124dns" IPAddress="10.124.1.4" />
      </DnsServers>
    </Dns>
    <VirtualNetworkSites>
      <VirtualNetworkSite name="n124" AffinityGroup="NorthEurope2Aff">
        <AddressSpace>
          <AddressPrefix>10.0.0.0/8</AddressPrefix>
        </AddressSpace>
        <Subnets>
          <Subnet name="Subnet-1">
            <AddressPrefix>10.124.1.0/24</AddressPrefix>
          </Subnet>
          <Subnet name="Subnet-2">
            <AddressPrefix>10.124.2.0/24</AddressPrefix>
          </Subnet>
          <Subnet name="Subnet-3">
            <AddressPrefix>10.124.3.0/24</AddressPrefix>
          </Subnet>
        </Subnets>
        <DnsServersRef>
          <DnsServerRef name="n124dns" />
        </DnsServersRef>
      </VirtualNetworkSite>
    </VirtualNetworkSites>
  </VirtualNetworkConfiguration>
</NetworkConfiguration>

from the portal, the virtual network looks like this:

Install the DNS Server

I install the DNS server as a Windows Server 2012 VM. It could also be a Linux machine, but I find it simpler to use a Windows Server which will also serve as a desktop environment for administrative tasks like browsing services like Ambari Server or Hadoop dashboards from a machine that has local access to the whole cluster.

I create a new Windows Server 2012 VM. For that, I go to the Windows Azure Management portal, and select NEW at the bottom left of the web page. Then,

Then I can connect to this machine from the portal:

from the Server Manager which can be started with this icon at the bootom left of the Desktop, I do the following:

I ignore the following warning:

After the installation, I can use the DNS configuration console that can be started that way:

I create a zone called n124.benjguin.com (benjguin.com is a domain I own) and its associated reverse lookup zone. Here is how it looks:

NB: you may also want to turn off the IE Enhanced Security Configuration here:

Create a Linux image

HDP documentation explains how to install on RPM based Linux OSs. CentOS is one of them. So let’s install CentOS virtual machines.

For that, I go to the Windows Azure Management portal, and select NEW at the bootom left of the web page. Then,

Yes

I’ll follow the Hortonworks’ documentation for a CentOS 6 OS. In particular, chapter 1.5 explains how to prepare the environment. I’ll give URLs in the documentation so that you can have the context, as well as the main steps I follow in my environment.

http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.2.2/bk_using_Ambari_book/content/ambari-chap1-5-2.html

ssh-keygen

(keep defaults)

sudo su

mkdir .ssh

cat /home/benjguin/.ssh/id_rsa.pub >> .ssh/authorized_keys

chmod 700 .ssh

chmod 640 .ssh/authorized_keys

# cf http://stackoverflow.com/questions/7268788/centos-6-sshd-server-refused-our-key

restorecon -R -v /root/.ssh

CTRL-D

ssh root@localhost should work without asking for a password

http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.2.2/bk_using_Ambari_book/content/ambari-chap1-5-5.html

sudo –s

setenforce 0

vi /etc/selinux/config

http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.2.2/bk_using_Ambari_book/content/ambari-chap1-5-6.html

sudo –s

chkconfig iptables off

/etc/init.d/iptables stop

http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.2.2/bk_using_Ambari_book/content/ambari-chap1-5-7.html

sudo –s

vi /etc/yum/pluginconf.d/refresh-packagekit.conf

sudo shutdown -h now

(…)

Now, I have my own Linux image. I’ll use it to create the different Linux VMs I need in my cluster.

Instanciate Linux virtual machines

sudo –s

vi /etc/hosts

sudo –s

fdisk –l

grep SCSI /var/log/messages

fdisk /dev/sdc

mkfs.ext3 /dev/sdc1

mkdir /mnt/datadrive

mount /dev/sdc1 /mnt/datadrive

vi /etc/fstab

add the following line at the end of the file:

/dev/sdc1 /mnt/datadrive ext3 defaults 1 2

The other machines in the cluster can be created thru the portal too. But that can also be done thru a script. There are two main flavors of automation scripts in Windows Azure: the Windows Azure PowerShell module can be used from Windows machines, the Command Line Interface (CLI for short, more information) which is based on Node.js can be used from Windows, Mac and Linux. They can be downloaded from http://www.windowsazure.com/en-us/downloads/.

As I’m a Windows guy, I will use PowerShell here. The details on how to start with the Windows Azure PowerShell cmdlets is available here.

Here is the script I use to create n124w1, n124w2 and n124w3:

Import-Module azure

#select default subscription and storage account

$subscription = 'Azure bengui'

Set-AzureSubscription -SubscriptionName $subscription -CurrentStorageAccount 'northeurope2affstorage'

Set-AzureSubscription -DefaultSubscription $subscription

#$adminPassword="******obfuscated*****"

+#region secret

#endregion

#create an empty collection of VMConfigs

$vms = @()

#loop on the three VM we want to create

for($i=1; $i -le 3; $i++)

{

Write-Host "creating n124w${i}OS"

$sshPort = 52200 + $i

#create a new VM Config

$newVM = `

New-AzureVMConfig -ImageName myCentOSImage -InstanceSize Medium -Name "n124w$i" `

-AvailabilitySetName "n124wAvailabilitySet" -DiskLabel "n124w${i}os" `

-HostCaching ReadWrite -Label "n124w$i" |

Add-AzureProvisioningConfig -Linux -LinuxUser "benjguin" -Password $adminPassword |

Add-AzureDataDisk -CreateNew -DiskLabel n124w${i}data1 -DiskSizeInGB 100 -LUN 0 |

Add-AzureEndpoint -LocalPort 22 -Name "SSH$i" -Protocol tcp -PublicPort $sshPort |

Set-AzureSubnet 'Subnet-3'

#add the VM config to the collection

$vms += ,$newVM

}

#show the collection

$vms | format-table

#create the VM

New-AzureVM -ServiceName 'n124' -VMs $vms -VNetName 'n124'

This generates the following output:

creating n124w1OS
creating n124w2OS
creating n124w3OS

AvailabilitySetName   ConfigurationSets     DataVirtualHardDisks Label                 OSVirtualHardDisk     RoleName              RoleSize             RoleType
-------------------   -----------------     -------------------- -----                 -----------------     --------              --------             --------
n124wAvailabilitySet {n124w1, Microsoft... {}                    bjEyNHcx              Microsoft.Samples.... n124w1                Medium               PersistentVMRole
n124wAvailabilitySet {n124w2, Microsoft... {}                    bjEyNHcy              Microsoft.Samples.... n124w2                Medium               PersistentVMRole
n124wAvailabilitySet {n124w3, Microsoft... {}                    bjEyNHcz              Microsoft.Samples.... n124w3                Medium               PersistentVMRole

WARNING: VNetName, DnsSettings, DeploymentLabel or DeploymentName Name can only be specified on new deployments.

OperationDescription                                      OperationId                                               OperationStatus
--------------------                                      -----------                                               ---------------
New-AzureVM - Create VM n124w1                            652a8988-df51-4777-94ae-bc7764296b0b                      Succeeded
New-AzureVM - Create VM n124w2                            5b165d43-dcc7-4f5d-a1fc-ae77c6fa62dd                      Succeeded
New-AzureVM - Create VM n124w3                            70750433-9f19-493c-9fdd-a8aad69fa193                      Succeeded

and that can be seen in the Windows Azure management portal:

The DNS server can be manually updated in order to obtain the following configuration:

Then, from n124m, I can connect to other machines like this:

From there, I can update /etc/hosts in order to have hostname and hostname –f having the right names.

I can also format the data disks.

These are the same steps as before for n124w*. To summarize, here a few screen shots for n124w2:

mkfs.ext3 /dev/sdc1

mkdir /mnt/datadrive

mount /dev/sdc1 /mnt/datadrive

vi /etc/fstab

add the following line at the end of the file:

/dev/sdc1 /mnt/datadrive ext3 defaults 1 2

(same for other n124w* machines).

Now I have a whole set of machines in the same network, and they are ready to have Hadoop installed on them.

Install Hadoop distribution

I can now start at step 2 of the installation in Hortonworks’ documentation.

connect to n124m

sudo su

rpm -Uvh http://public-repo-1.hortonworks.com/ambari/centos6/1.x/GA/ambari-1.x-1.el6.noarch.rpm

from http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.2.2/bk_using_Ambari_book/content/ambari-chap2.1.2.html,

yum install epel-release

yum install ambari-server

(…)

from http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.2.2/bk_using_Ambari_book/content/ambari-chap2-2.html

ambari-server setup

(I use default answers during the setup)

from http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.2.2/bk_using_Ambari_book/content/ambari-chap2-3.html

ambari-server start

I am now at step 3 of the Hortonworks’ documentation

http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.2.2/bk_using_Ambari_book/content/ambari-chap3-1.html states to connect to http://{main.install.hostname}:8080. I do that from the Windows Server machine which is in the local network where the Linux machines are.

NB: in order to connect to n124dns, one simple way is to select this VM in the Windows Azure management portal and click Connect:

In a remote desktop on the n124dns machine, I do the following:

I connect with admin/admin

Next screen asks for the .ssh/id_rsa key. The simplest way is to copy it from an ssh session (benjguin@n124.cloudapp.net:22 in my case) and paste it in the browser.

in the customize services web page, I have

I choose to remove /mnt/resource folders because it corresponds to a disk that lives with the VM and which is not persisted in the Windows Azure storage folder. This disk is destroyed when one destroys the VM. HDFS would support it, but I want to be able to stop my whole cluster without loosing HDFS data. So I change to the following:

I do the same in tab MapReduce

I also enter the required passwords and click Next

the detail is the following

Admin Name : admin

Cluster Name : n124hdp

Total Hosts : 4 (4 new)

Local Repository : No

Services

HDFS

NameNode : n124m.n124.benjguin.com

SecondaryNameNode : n124w1.n124.benjguin.com

DataNodes : 3 hosts

MapReduce

JobTracker : n124m.n124.benjguin.com

TaskTrackers : 3 hosts

Nagios

Server : n124m.n124.benjguin.com

Administrator : nagiosadmin / (web@benjguin.com)

Ganglia

Server : n124m.n124.benjguin.com

Hive + HCatalog

Hive Metastore : n124m.n124.benjguin.com

Database : MySQL (New Database)

HBase

Master : n124m.n124.benjguin.com

Region Servers : 3 hosts

Oozie

Server : n124m.n124.benjguin.com

ZooKeeper

Servers : 3 hosts

…

Run

Let’s now test HDFS, PIG and HIVE by ourselves in this cluster.

I open a new SSH connection to the master node (n124m, available at n124.cloudapp.net:22)

let’s copy /etc/paswd file to /hwork/in HDFS folder

[benjguin@n124m ~]$ cp test.pig /tmp
[benjguin@n124m ~]$ cd /tmp
[benjguin@n124m tmp]$ cat test.pig
A = load '/hwork/in' using PigStorage(':');
B = foreach A generate \$0 as id;
store B into '/hwork/out1';
[benjguin@n124m tmp]$ sudo -u hdfs pig test.pig
2013-04-05 10:54:08,586 [main] INFO org.apache.pig.Main - Apache Pig version 0.10.1.23 (rexported) compiled Mar 28 2013, 12:20:36
2013-04-05 10:54:08,587 [main] INFO org.apache.pig.Main - Logging error messages to: /tmp/pig_1365159248577.log
2013-04-05 10:54:09,141 [main] INFO org.apache.pig.backend.hadoop.executionengine.HExecutionEngine - Connecting to hadoop file system at: hdfs://n124m.n124.benjguin.com:8020
2013-04-05 10:54:09,318 [main] INFO org.apache.pig.backend.hadoop.executionengine.HExecutionEngine - Connecting to map-reduce job tracker at: n124m.n124.benjguin.com:50300
2013-04-05 10:54:10,104 [main] INFO org.apache.pig.tools.pigstats.ScriptState - Pig features used in the script: UNKNOWN
2013-04-05 10:54:10,294 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MRCompiler - File concatenation threshold: 100 optimistic? false
2013-04-05 10:54:10,323 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MultiQueryOptimizer - MR plan size before optimization: 1
2013-04-05 10:54:10,323 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MultiQueryOptimizer - MR plan size after optimization: 1
2013-04-05 10:54:10,431 [main] INFO org.apache.pig.tools.pigstats.ScriptState - Pig script settings are added to the job
2013-04-05 10:54:10,469 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler - mapred.job.reduce.markreset.buffer.percent is not set, set to default 0.3
2013-04-05 10:54:10,471 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler - creating jar file Job5927476079760658662.jar
2013-04-05 10:54:14,037 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler - jar file Job5927476079760658662.jar created
2013-04-05 10:54:14,061 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler - Setting up single store job
2013-04-05 10:54:14,101 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - 1 map-reduce job(s) waiting for submission.
2013-04-05 10:54:14,603 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - 0% complete
2013-04-05 10:54:15,036 [Thread-7] INFO org.apache.hadoop.mapreduce.lib.input.FileInputFormat - Total input paths to process : 1
2013-04-05 10:54:15,036 [Thread-7] INFO org.apache.pig.backend.hadoop.executionengine.util.MapRedUtil - Total input paths to process : 1
2013-04-05 10:54:15,052 [Thread-7] WARN org.apache.hadoop.io.compress.snappy.LoadSnappy - Snappy native library is available
2013-04-05 10:54:15,053 [Thread-7] INFO org.apache.hadoop.util.NativeCodeLoader - Loaded the native-hadoop library
2013-04-05 10:54:15,053 [Thread-7] INFO org.apache.hadoop.io.compress.snappy.LoadSnappy - Snappy native library loaded
2013-04-05 10:54:15,056 [Thread-7] INFO org.apache.pig.backend.hadoop.executionengine.util.MapRedUtil - Total input paths (combined) to process : 1
2013-04-05 10:54:16,311 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - HadoopJobId: job_201304050850_0005
2013-04-05 10:54:16,311 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - More information at: http://n124m.n124.benjguin.com:50030/jobdetails.jsp?jobid=job_201304050850_0005
2013-04-05 10:54:26,873 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - 50% complete
2013-04-05 10:54:30,936 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - 100% complete
2013-04-05 10:54:30,938 [main] INFO org.apache.pig.tools.pigstats.SimplePigStats - Script Statistics:

HadoopVersion PigVersion UserId StartedAt FinishedAt Features
1.1.2.23 0.10.1.23 hdfs 2013-04-05 10:54:10 2013-04-05 10:54:30 UNKNOWN

Success!

Job Stats (time in seconds):
JobId Maps Reduces MaxMapTime MinMapTIme AvgMapTime MaxReduceTime MinReduceTime AvgReduceTime Alias Feature Outputs
job_201304050850_0005 1 0 3 3 3 0 0 0 A,B MAP_ONLY /hwork/out1,

Input(s):
Successfully read 45 records (2588 bytes) from: "/hwork/in"

Output(s):
Successfully stored 45 records (304 bytes) in: "/hwork/out1"

Counters:
Total records written : 45
Total bytes written : 304
Spillable Memory Manager spill count : 0
Total bags proactively spilled: 0
Total records proactively spilled: 0

Job DAG:
job_201304050850_0005

2013-04-05 10:54:30,954 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - Success!
[benjguin@n124m tmp]$

so PIG works!

let’s now do the same thing with HIVE:

that works too!

Automate the cluster [de]provisioning

Once I have the VMs setup, I want to be able to stop paying for compute by shutting down and removing the VMs (while still keeping the virtyual hard disks VHD).

Il also want to be able to restart the whole cluster quite quickly.

As seen before in this post, it is possible to automate by scripting. Here are the scripts I use to stop and start this cluster.

NB: I took the OS disk names and data disk names from the Windows Azure portal

To shut up the cluster, I use

#region init

Import-Module 'c:\Program Files (x86)\Microsoft SDKs\Windows Azure\PowerShell\Azure\Azure.psd1'

$subscription = 'Azure bengui'

Set-AzureSubscription -SubscriptionName $subscription -CurrentStorageAccount 'northeurope2affstorage'

Set-AzureSubscription -DefaultSubscription $subscription

$cloudSvcName = 'n124'

#endregion

#region shutdown and delete

echo 'will shut down and remove the following'

#$vms = Get-AzureVM -ServiceName $cloudSvcName | where { !($_.name -eq 'n124dns') }

$vms = Get-AzureVM -ServiceName $cloudSvcName

$vms | select name

$vms | Stop-AzureVM

$vms | Remove-AzureVM

#endregion

To startup the cluster, I use:

Import-Module azure

$subscription = 'Azure bengui'

Set-AzureSubscription -SubscriptionName $subscription -CurrentStorageAccount 'northeurope2affstorage'

Set-AzureSubscription -DefaultSubscription $subscription

$cloudSvcName = 'n124'

$vNetName = 'n124'

$vms = @()

$vmName='n124dns'

$n124dns = New-AzureVMConfig -DiskName 'n124dns-n124dns-0-20130117132807' -InstanceSize Small -Name $vmName -Label $vmName |

Set-AzureSubnet 'Subnet-1' |

Add-AzureEndpoint -LocalPort 3389 -Name 'RDP' -Protocol tcp -PublicPort 3389

$vms += ,$n124dns

$vmName='n124m'

$vm1 = New-AzureVMConfig -DiskName 'n124-n124m-2013-04-03' -InstanceSize Medium -Name $vmName -Label $vmName |

Add-AzureDataDisk -DiskName 'n124-n124m-0-201304031626300873' -Import -LUN 0 |

Add-AzureEndpoint -LocalPort 22 -Name 'SSH' -Protocol tcp -PublicPort 22 |

Set-AzureSubnet 'Subnet-2'

$vms += ,$vm1

$osDiskNames = @('n124-n124w1-0-201304041529430938', `

'n124-n124w2-0-201304041530370691', `

'n124-n124w3-0-201304041532060509')

$dataDiskNames = @('n124-n124w1-0-201304041529470297', `

'n124-n124w2-0-201304041530410363', `

'n124-n124w3-0-201304041532090540')

#loop on the three VM we want to create

for($i=1; $i -le 3; $i++)

{

Write-Host "creating n124w${i}OS"

$sshPort = 52200 + $i

$j = $i - 1

#create a new VM Config

$newVM = `

New-AzureVMConfig -DiskName $osDiskNames[$j] -InstanceSize Medium -Name "n124w$i" `

-AvailabilitySetName "n124wAvailabilitySet" -Label "n124w$i" |

Add-AzureDataDisk -DiskName $dataDiskNames[$j] -Import -LUN 0 |

Add-AzureEndpoint -LocalPort 22 -Name "SSH$i" -Protocol tcp -PublicPort $sshPort |

Set-AzureSubnet 'Subnet-3'

#add the VM config to the collection

$vms += ,$newVM

}

#show the collection

$vms | format-table

#create the VM

New-AzureVM -ServiceName 'n124' -VMs $vms -VNetName 'n124'

So I now have a Linux cluster with Hadoop installed and I can start, and stop it (without loosing HDFS data) with scripts.

Benjamin

How to use Windows Azure with a Windows Azure Active Directory account

Benjamin GUINEBERTIERE — Tue, 05 Mar 2013 15:49:00 GMT

There has been some news about Windows Azure Active Directory recently. Yesterday an announce has been made about a deeper integration between Windows Azure portal and Windows Azure Active Directory (http://blogs.msdn.com/b/windowsazure/archive/2013/03/04/more-identity-and-access-management-improvements-in-windows-azure.aspx).

I had created a Windows Azure Active Directory standalone tenant a few weeks ago. You can do this yourself; it is available at https://activedirectory.windowsazure.com/Signup/QuickSignup.aspx?ru=https://activedirectory.windowsazure.com/default.aspx&ali=1.

In order to access Windows Azure resources from a Windows Azure Active Directory (from now on WAAD) account, it is possible to go the Windows Azure Management portal (https://manage.windowsazure.com) and connect like an Office 365 user. In this case we’ll see how to create a free subscription with this account.

Browse to https://manage.windowsazure.com

you receive a text message on your phone that you can enter:

You can then fill the following form. Note that the e-mail can be changed to an e-mail address where you prefer to receive messages (this may not be the same as your WAAD account).

Click Next, and the subscription will be created

before you are redirected to the following page:

click on the Portal link in the upper right corner. You get a few welcome screens that show how the portal works:

then you get the usual experience:

In the Active Directory part of the portal, you can access your WAAD domain and manage users. In particular, you can create a co-admin account and ensure this account connects only with 2 factor authentication:

Add the user as a co-admin

Then, this user can connect thru https://activedirectory.windowsazure.com

you receive an SMS on your phone and you are asked to answer it with a code

Type the code on the phone and answer the SMS

Then this user can connect to the management portal

Benjamin

Sample Windows Azure Virtual Machines PowerShell Scripts

Benjamin GUINEBERTIERE — Tue, 18 Dec 2012 18:07:50 GMT

I sometimes show a platform that requires a bunch of Windows Azure virtual machines. It has 1 Active Directory domain controller (n123dc1), 3 SQL Server VMs for database mirroring (n123sql1, n123sql2, and n123sp20131 which also happens to have a SharePoint Server 2013 installed), and 2 members of a SharePoint 2012 Web Front End.

Between two demo sessions, I keep the VHD files in Windows Azure blob storage, as well as the virtual network because they don’t cost too much, but I don’t let the virtual machines deployed so that they don’t cost anything.

In order to restart the whole platform I use the following script (I slightly obfuscated one or two values).

#region init
Import-Module 'c:\Program Files (x86)\Microsoft SDKs\Windows Azure\PowerShell\Azure\Azure.psd1'

$subscription = 'Azdem169B44999X'
Set-AzureSubscription -SubscriptionName $subscription -CurrentStorageAccount 'storrageazure2'
Set-AzureSubscription -DefaultSubscription $subscription

$cloudSvcName = 'n123'
#endregion

#region DC
$vmName='n123dc1'
$disk0Name = 'n123dc1-n123dc1-0-20120912092405'
$disk1Name = 'n123dc1-n123dc1-0-20120912105309'
$vNetName = 'Network123'
$subNet = 'DCSubnet'

$vm1 = New-AzureVMConfig -DiskName $disk0Name -InstanceSize ExtraSmall -Name $vmName -Label $vmName |
    Add-AzureDataDisk -DiskName $disk1Name -Import -LUN 0 |
    Set-AzureSubnet $subNet |
    Add-AzureEndpoint -LocalPort 3389 -Name 'RDP' -Protocol tcp -PublicPort 50101

New-AzureVM -ServiceName $cloudSvcName -VMs $vm1 -VNetName $vNetName
#endregion

#region SQL Server
$vmName='n123sql1'
$disk0Name = 'n123dc1-n123sql1-0-20120912170111'
$disk1Name = 'n123dc1-n123sql1-0-20120913074650'
$disk2Name = 'n123dc1-n123sql1-1-20120913080403'
$vNetName = 'Network123'
$subNet = 'SQLSubnet'
$availabilitySetName = 'SQL'

$sqlvms = @()

$vm1 = New-AzureVMConfig -DiskName $disk0Name -InstanceSize Medium -Name $vmName -Label $vmName -AvailabilitySetName $availabilitySetName |
    Add-AzureDataDisk -DiskName $disk1Name -Import -LUN 0 |
    Add-AzureDataDisk -DiskName $disk2Name -Import -LUN 1 |
    Set-AzureSubnet $subNet |
    Add-AzureEndpoint -LocalPort 3389 -Name 'RDP' -Protocol tcp -PublicPort 50604 |
    Add-AzureEndpoint -LocalPort 1433 -Name 'SQL' -Protocol tcp -PublicPort 14330

$sqlvms += ,$vm1

$vmName='n123sql2'
$disk0Name = 'n123-n123sql2-0-20121120105231'
$disk1Name = 'n123-n123sql2-0-20121120144521'
$disk2Name = 'n123-n123sql2-1-20121120145236'
$vm2 = New-AzureVMConfig -DiskName $disk0Name -InstanceSize Small -Name $vmName -Label $vmName -AvailabilitySetName $availabilitySetName |
    Add-AzureDataDisk -DiskName $disk1Name -Import -LUN 0 |
    Add-AzureDataDisk -DiskName $disk2Name -Import -LUN 1 |
    Set-AzureSubnet $subNet |
    Add-AzureEndpoint -LocalPort 3389 -Name 'RDP' -Protocol tcp -PublicPort 50605 |
    Add-AzureEndpoint -LocalPort 1433 -Name 'SQL' -Protocol tcp -PublicPort 14331

$sqlvms += ,$vm2

New-AzureVM -ServiceName $cloudSvcName -VMs $sqlvms
#endregion

#region SharePoint
$vmNamesp1='n123sp1'
$vmNamesp2='n123sp2'
$disk0Namesp1 = 'n123-n123sp1-2012-09-13'
$disk0Namesp2 = 'n123-n123sp2-2012-09-13'
$vNetName = 'Network123'
$subNet = 'SharePointSubnet'
$availabilitySetName = 'WFE'

$spvms = @()

$vm1 = New-AzureVMConfig -DiskName $disk0Namesp1 -InstanceSize Small -Name $vmNamesp1 -Label $vmNamesp1 -AvailabilitySetName $availabilitySetName |
    Set-AzureSubnet $subNet |
    Add-AzureEndpoint -LocalPort 3389 -Name 'RDP' -Protocol tcp -PublicPort 50704 |
    Add-AzureEndpoint -LocalPort 80 -Name 'HttpIn' -Protocol tcp -PublicPort 80 -LBSetName "SPFarm" -ProbePort 80 -ProbeProtocol "http" -ProbePath "/probe/"
$spvms += ,$vm1

$vm2 = New-AzureVMConfig -DiskName $disk0Namesp2 -InstanceSize Small -Name $vmNamesp2 -Label $vmNamesp2 -AvailabilitySetName $availabilitySetName |
    Set-AzureSubnet $subNet |
    Add-AzureEndpoint -LocalPort 3389 -Name 'RDP' -Protocol tcp -PublicPort 50705 |
    Add-AzureEndpoint -LocalPort 80 -Name 'HttpIn' -Protocol tcp -PublicPort 80 -LBSetName "SPFarm" -ProbePort 80 -ProbeProtocol "http" -ProbePath "/probe/"
$spvms += ,$vm2

New-AzureVM -ServiceName $cloudSvcName -VMs $spvms
#endregion

#region SharePoint 2013 and SQL Server witness
$vmName='n123sp20131'
$disk0Name = 'n123-n123sp20131-0-20121120104314'
$disk1Name ='n123-n123sp20131-0-20121120220458'
$vNetName = 'Network123'
$subNet = 'SP2013Subnet'
$availabilitySetName = 'SQL'

$vm1 = New-AzureVMConfig -DiskName $disk0Name -InstanceSize Small -Name $vmName -Label $vmName -AvailabilitySetName $availabilitySetName |
    Add-AzureDataDisk -DiskName $disk1Name -Import -LUN 0 |
    Set-AzureSubnet $subNet |
    Add-AzureEndpoint -LocalPort 3389 -Name 'RDP' -Protocol tcp -PublicPort 50804 |
    Add-AzureEndpoint -LocalPort 80 -Name 'HttpIn' -Protocol tcp -PublicPort 8080

New-AzureVM -ServiceName $cloudSvcName -VMs $vm1
#endregion

In order to stop the whole platform, I use the following script:

#region init
Import-Module 'c:\Program Files (x86)\Microsoft SDKs\Windows Azure\PowerShell\Azure\Azure.psd1'

$subscription = 'Azdem169B44999X'
Set-AzureSubscription -SubscriptionName $subscription -CurrentStorageAccount 'storrageazure2'
Set-AzureSubscription -DefaultSubscription $subscription

$cloudSvcName = 'n123'
#endregion

#region shutdown and delete
echo 'will shut down and remove the following'
Get-AzureVM -ServiceName $cloudSvcName | select name
Get-AzureVM -ServiceName $cloudSvcName | Stop-AzureVM
Get-AzureVM -ServiceName $cloudSvcName | Remove-AzureVM
#endregion

In order to get started, I read Michael Washam’s blog.

Benjamin

Avoid sending a partially written e-mail | Eviter d’envoyer un e-mail en cours d’écriture

Benjamin GUINEBERTIERE — Thu, 08 Nov 2012 00:29:47 GMT

I regularly use the following trick while writing an e-mail so that I don’t send it by error before it is fully written:	J’utilise régulièrement le truc suivant lorsque j’écris des e-mails, de façon à ne pas envoyer par erreur un message encore en cours de rédaction et que je n’ai pas encore relu:
I put a user called “attendre” (this means “wait” in French).	Je mets un utilisateur “attendre” en copie.
If by mistake, I press the send button before removing attendre, the e-mail doesn’t get sent because attendre does not exist, and it is not a valid address either.	Si par erreur, j’appuie sur le bouton d’envoi avant d’avoir supprimé attendre, l’e-mail ne part pas car attendre n’existe pas, et ne correspond pas non plus à une adresse e-mail valide.

I use the trick with Outlook but I suppose this would work with most e-mail clients as well.

J’utilise ce truc avec Outlook mais je suppose que cela fonctionnerait également avec la plupart des clients de messagerie également.

Benjamin

Installing HDInsight (Hadoop) on a single Windows box | Installation d’HDInsight (Hadoop) sur une machine Windows

Benjamin GUINEBERTIERE — Wed, 31 Oct 2012 18:51:40 GMT

Announced at the //build conference, HDInsight is available as a Web Platform Installer installation. This allows to have Hadoop on a Windows box (like a laptop) without requiring cygwin.	Comme annoncé à la conférence //build, HDInsight est disponible à l’installation depuis Web Platform Installer. Cela permet d’avoir Hadoop sur une machine Windows (un portable par exemple) sans nécessiter cygwin.
Let’s see how to install this from a blank Windows Server 2012 server (example).	Voyons ce que donne cette installation depuis une toute nouvelle machine sous Windows Server 2012 par exemple.

Go to http://www.microsoft.com/web

aller à http://www.microsoft.com/web

This installed the Web Platform Installer	Cela a installé le Web Platform Installer
Type HDInsight in the search box and press ENTER	taper HDInsight dans la boîte de recherche et taper sur ENTREE

…

Benjamin

Hadoop + SSIS, SSIS + Windows Azure Blob Storage

Benjamin GUINEBERTIERE — Thu, 18 Oct 2012 22:39:35 GMT

I worked on a white paper which has just been published on MSDN

J’ai travaillé sur un livre blanc qui vient d’être publié sur MSDN

Leveraging a Hadoop cluster from SQL Server Integration Services (SSIS)

I’d like to point out that the paper comes with sample code (thanks Rémi!) that can also be used besides Hadoop as it enables data movement to and from Windows Azure Blob storage from SQL Server’s ETL: SSIS.	J’en profite pour préciser que le livre blanc est fourni avec du code exemple (merci Rémi!) qui peut être utilisé indépendamment d’Hadoop puisqu’il permet de copier des données vers et depuis les blobs Azure depuis l’ETL de SQL Server: SSIS.
The code samples are available at the following URLs:	Les URLs des exemples de code sont les suivantes:

SSIS Packages Sample for Hadoop and Windows Azure

HadoopOnAzure REST API Wrapper Sample

Azure Blob Storage Components for SSIS Sample

Benjamin

How to download a blob on a linux machine | Comment télécharger un blob sur une machine Linux

Benjamin GUINEBERTIERE — Fri, 12 Oct 2012 14:50:44 GMT

I suppose you have a Windows machine and a Linux machine. You want to get a blob directly from Blob storage to the Linux machine.	Je suppose ici qu’on a une machine Windows et une machine Linux. On veut récupérer un blob directement du blob storage à la machine Linux.
On the Windows machine, use a tool like CloudXplorer to create a Shared Access Signature.	Sur la machine Windows, utiliser un outil tel que CloudXplorer pour créer une Shared Access Signature.

copy the shared access signature which is a URL with authorization to download the private blob. Check the start date, don’t add more time than 1 hour for the authorized download window (that would require a policy at the container level, which is more complicated).	copier la shared access signature qui est une URL qui inclut une autorisation de télécharger le blob privé. Cocher la date de départ, ne pas ajouter plus qu’une heure pour la fenêtre de téléchargement autorisée (on aurait besoin d’une règle au niveau conteneur, ce qui est un peu plus compliqué)
On the Linux machine, paste that URL in a curl command like below:	Sur la machine Linux, coller l’URL dans une commande curl tel que ci-dessous:

This technique could also be used to upload blobs, by creating a write shared access signature and use HTTP PUT instead of GET.

Cette technique peut aussi être utilisée pour charger vers des blobs, en créant une shared access signature en écriture et en utilisant HTTP PUT au lieu de GET.

Benjamin

Installing MediaWiki to free Windows Azure Web Sites | Installation de MediaWiki vers les Windows Azure Web Sites gratuits

Benjamin GUINEBERTIERE — Tue, 25 Sep 2012 14:54:06 GMT

One of the most famous wiki engines is MediaWiki; You may not know its name, but you may know Wikipedia which is running it!	Un des moteurs de wiki les plus connus est MediaWiki. Vous ne connaissez peut-être pas son nom, mais vous pouvez avoir entendu parler de Wikipedia qui l’utilise comme moteur !
Let’s see how to install such a Wiki on Windows Azure Web Sites.	Voyons comment installer un tel Wiki sur Windows Azure Web Sites.

The free open source software can be downloaded from the following Url:

Ce logiciel open source et gratuit peut être téléchargé depuis l’URL suivante :

http://www.mediawiki.org/wiki/Download

The file is mediawiki-1.19.2.tar.gz which can be uncompressed on Windows with a tool like 7-Zip. So let’s unblock and ungzip the file.

Le fichier est mediawiki-1.19.2.tar.gz qui, sur Windows, peut être décompressé avec l’outil 7-Zip. Déblocons et décompressons le fichier téléchargé.

Once I get the files locally, I can upload to a Windows Azure Web Site. For that, I need to create a new Windows Azure Web Site with a MySql database, by using the http://manage.windowsazure.com Windows Azure portal.

Une fois que j’ai les fichiers localement, je peux les charger vers une site Web Windows Azure. Pour cela, j’ai besoin de créer un site Windows Azure et sa base MySql, en utilisant le portail Windows Azure à http://manage.windowsazure.com.

It is possible to reset the deployment credentials. The other parameters are available for copy from the portal.

Il est possible de réinitialiser le mot de passe servant au déploiement. Les autres paramètres de déploiement peuvent être copiés depuis le portail.

Those parameters can be pasted in an FTP client such as FileZilla. I’ll use that tool to copy the PHP files to the newly created Windows Azure Web Site.

Ces paramètres peuvent ensuite être collés dans un client FTP tel que FileZilla. C’est à partir de cet outil que je copierai les fichiers PHP vers le nouveau site Web Windows Azure.

It is now possible to navigate to the site. The url can be found in the Windows Azure portal.

A ce stade, il est possible de naviguer vers le site. L’Url peut être trouvée dans le portail Windows Azure.

the MySql database parameters can be found in the configure tab.

Les paramètres de la base MySql sont disponibles dans l’onglet “configure”.

The parameters can be copied from the connection string and pasted to the configuration web page

Les paramètres peuvent être copiés de la chaîne de connexion et collés dans la page de configuration

This generates a php settings file that I can download

Cela génère un fichier PHP de paramétrage que je peux télécharger

the file should then be uploaded to the site, under the root

le fichier peut ensuite être chargé dans le site, juste sous la racine

then, I can browse the site

Je peux ensuite aller sur le site

In order to change the logo, besides uploading the file with FTP, PHP code needs to be changed. This can be done very easily by using WebMatrix.

De façon à changer le logo, outre le fait de charger l’image elle-même par FTP, il faut changer du code. Cela peut être fait très facilement avec WebMatrix.

When asked about local installation, I just click cancel in order to have the remote view only, then I edit the right file with WebMatrix editor and save.

Quand je me vois poser la question à propos d’une installation du site en local, je clique sur “Cancel” (annuler) de façon à n’avoir que la vue du site distant. Puis j’édite le bon fichier dans WebMatrix avant de sauvegarder.

the site is functional. I can start modifying the content of the wiki.

Le site est fonctionnel. Je peux modifier le contenu du wiki

Benjamin

Migrating TailspinSpyworks Web Forms to Windows Azure | Migration de l’appli Web Forms TailspinSpyworks vers Windows Azure

Benjamin GUINEBERTIERE — Tue, 18 Sep 2012 20:47:55 GMT

Windows Azure Web Sites makes it easy to create new Web Sites. A site can be empty, created from a popular framework such as Wordpress or Umbraco, or the result of a migration from an existing app.	Les sites Web Windows Azure simplifient la création de nouveaux sites Web. Un tel site peut être vide, créé à partir d’un Framework populaire tel que Wordpress ou Umbraco, ou être le résultat de la migration d’une application existante.
In order to test these features yourself, you can benefit from a 90 day free trial offer, and activate the preview web sites feature.	si vous souhaitez tester ces fonctionnalités par vous même, vous pouvez profiter d'une offre d'essai gratuit pendant 90 jours, et activer la fonctionnalité des sites Web actuellement en test.
A lot is being written about ASP.NET MVC which is awesome, but legacy applications may still be written as ASP.NET Web Forms (Note that most of this post can also be applied to other ASP.NET apps like an MVC one!).	On écrit beaucoup à propos d’ASP.NET MVC qui est excellent, mais les applications existantes risquent fort d’être de type Web Forms ASP.NET (NB: une bonne partie de ce billet s’applique à ASP.NET en général et donc à MVC!).
Let’s see how to migrate such an ASP.NET Web Forms App. to Windows Azure Web Sites.	Voyons comment migrer une telle application ASP.NET Web Forms vers les sites Web Windows Azure.
TailspinSpyworks is one of the available samples on ASP.NET reference web site. It can be found at http://www.asp.net/web-forms/samples which leads to the following download.	TailspinSpyworks est un des exemples sur le site de référence d’ASP.NET. On peut le trouver à http://www.asp.net/web-forms/samples qui amène au site de téléchargement suivant.

The first part of this post is about downloading the sample and make it run locally. Then I’ll show how to migrate it to Windows Azure.

La première partie de ce billet est consacrée à la façon de télécharger cet exemple et le faire fonctionner localement avant de le migrer vers Windows Azure.

My development machine has Visual Studio 2012, SQL Server 2012, and the latest SQL Server Data Tools (SSDT) that can be donwloaded for Visual Studio 2012.	Ma machine de développement a Visual Studio 2012, SQL Server 2012, et les derniers outils SQL Server Data Tools (SSDT) qui peuvent être téléchargés pour Visual Studio 2012.
The solution was written with previous generation tools, but it was already targetting .NET Framework 4.0 and I won’t change that.	La solution a été écrite avec la génération précédente des outils, mais elle cible le .NET Framework 4.0 et l’on ne va pas changer cela.
After unblocking the zip file I downloaded from codeplex and unzipping to D:\dev\TailspinSpyworks-v0.9, I get the following:	Après avoir débloqué le fichier zip que j’ai téléchargé depuis codeplex et dézippé vers D:\dev\TailspinSpyworks-v0.9, j’obtiens cela:

I open the solution in Visual Studio 2012.	J’ouvre la solution dans Visual Studio 2012.
I have a simple report with just a few warnings that I can ignore.	J’'obtiens un rapport avec juste quelques warnings que je peux ignorer

The solution uses two different databases. The ASP.NET database and the commerce database. The first one contains data for ASP.NET services like membership and the commerce DB contains the core application data.

La solution utilise deux bases de données différentes. La base ASP.NET et la base Commerce. La première contient des services ASP.NET telle que les comptes et la base commerce contient les données de base de l’application.

The database connection strings suppose you have SQL Server Express. In my case, I have a SQL Server 2012 developer edition so I just move the files from App_Data in the project to the SQL Server Data folder and attach the files in that SQL Server 2012 developer edition instance. The details are beyond the scope of this post.

Les chaines de connexion des bases de données supposent l’utilisation de SQL server Express. Dans mon cas, j’ai SQL Server 2012 developer edition; je déplace donc les fichiers depuis App_Data du projet pour les attacher à cette instance SQL Server 2012 developer edition. Les détails exacts vont au delà de ce billet.

(…)

I also remove the user that corresponds to the developer as it is not used by the project. There’s an associated schema which is not used either and that can also be removed.

J’enlève également l’utilisateur qui correspond au développeur puisqu’il n’est pas utilisé dans ce projet. Il y a également un schéma associé qui n’est pas non plus utilisé et que je supprime également.

Then, it is also possible to view those databases from the SSDT; this is a way to get the connection strings, amongst other things.

Il est ensuite possible de voir ces mêmes bases de données depuis SSDT, de façon à obtenir les chaînes de connexion, entre autres.

Then the 2 local connection strings can be updated in the Web.config file. In my case, they change from

Puis les 2 chaînes de connexion locale peuvent être mises à jour dans le fichier Web.config. Dans mon cas, on les change de

    <connectionStrings>
    <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
    <add name="CommerceEntities" connectionString="metadata=res://*/Data_Access.EDM_Commerce.csdl|res://*/Data_Access.EDM_Commerce.ssdl|res://*/Data_Access.EDM_Commerce.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Commerce.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

vers

  <connectionStrings>
    <add name="ApplicationServices" connectionString="Data Source=.;Initial Catalog=ASPNETDB-TAILSPINSPYWORKS.MDF;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False" providerName="System.Data.SqlClient" />
    <add name="CommerceEntities" connectionString="metadata=res://*/Data_Access.EDM_Commerce.csdl|res://*/Data_Access.EDM_Commerce.ssdl|res://*/Data_Access.EDM_Commerce.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.;Initial Catalog=COMMERCE-TAILSPINSPYWORKS.MDF;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

then I start locally the App.

puis je peux démarrer l’application.

I also had to fix a few things in the code like this one in D:\dev\TailspinSpyworks-v0.9\TailspinSpyworks\Error.aspx.cs

J’ai aussi dû corriger deux ou trois choses dans le code comme cela dans le fichier D:\dev\TailspinSpyworks-v0.9\TailspinSpyworks\Error.aspx.cs

…

namespace TailspinSpyworks
{
    public partial class Error : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            Label_ErrorFrom.Text = Request["Err"].ToString();
            // there might be no Inner Exception. 
            //Label_ErrorMessage.Text = Request["InnerErr"].ToString();
            // string.Format will apply ToString() only to non null arguments
            Label_ErrorMessage.Text = string.Format("{0}", Request["InnerErr"]);
        }
    }
}

as well as recreate an empty event for the ProductDetails.aspx page. The event was not there and generated an exception:

ou comme recréer un évenement vide pour la page ProductDetails.aspx. L’événement était absent et générait une exception:

        protected void FormView_Product_PageIndexChanging(object sender, FormViewPageEventArgs e)
        {
            // this event was recreated but is not handled
        }

so for now, I just made the sample app working on my machine. I didn’t start the migration to Windows Azure yet! So I mark the post with an <hr/>

Donc jusqu’à présent j’ai juste fait fonctionner l’application sur ma machine. Je n’ai pas encore commencé la migration vers Windows Azure! Je marque donc le billet d’un <hr/>

OK, let’s start the migration now!	OK, démarrons la migration maintenant!
First I create a new Windows Azure Web Site named TailspinSpyworks, with an associated Windows Azure SQL database. In this case, I create a database in an existing Windows Azure SQL database server, but I could also create a new server as well.	Pour commencer je crée un nouveau site Web Windows Azure appelé TailspinSpyworks, avec une base de données Windows Azure SQL Database. Ici, je crée une base dans un serveur Windows Azure SQL Database existant, mais j’aurais aussi pu créer un nouveau serveur.
This is done from the Windows Azure portal, at http://manage.windowsazure.com.	Cela se fait depuis le portail Windows Azure, à http://manage.windowsazure.com.

A few seconds later, I have an empty web site with its associated Windows Azure SQL Database where I’ll be able to host the migrated Web Forms app.

Quelques secondes après, j’ai un site Web vide avec une base de données Windows Azure SQL Database associée où je vais pouvoir hébergée l’application migrée.

I will get and download from the portal the publishing profile of the new web site.

Je vais récupérer et télécharger depuis le portail le profil de publication du nouveau site Web.

Now, I can start publishing from Visual Studio 2012.

Maintenant, je peux démarrer une publication depuis Visual Studio 2012.

The next screen is the most important one

L’écran suivant est le plus important

I check the “remove additional files at destination” because I know my local app has the whole content and I can remove the default index page once the App is deployed.

Je sélectionne “remive additional files at destination” parce que je sais que mon application locale a tout le contenu dont j’ai besoin et je peux donc supprimer la page d’index par défaut une fois que l’application aura été déployée.

The first database (ASPNETDB…) can have its schema recreated in Windows Azure SQL Database at runtime instead of being migrated. You can find more information on this in blog post by a Scott Handelman about ASP.NET Universal providers that are compatible with Windows Azure SQL Database. Of course, you can also follow the link provided by the UI. So I click on the biggest button!

Le schéma de la première base (ASPNETDB…) peut être recréé au moment de l’exécution dans Windows Azure SQL Database plutôt que de migrer la base. Vous trouverez plus d’information dans ce billet de Scott Handelman à propos des fournisseurs universels ASP.NET qui sont compatibles avec Windows Azure SQL Database. Bien sûr, vous pouvez aussi suivre le lien fourni dans l’interface graphique. Tout cela pour dire que je clique sur le plus gros bouton!

and I accept to close the Wizard and install

et j’accepte de fermer l’assistant pour installer

The details about this are provided in the link. I will create such a user once the App is in the cloud. So let’s move on by restarting the publishing Wizard.

Les détails sont fournis dans le lien. Je vais créer un utilisateur de l’application une fois que cette dernière sera hébergée dans Windows Azure. Avançons et redémarrons l’assistant de migration.

The “ApplicationServices” connection string has been replaced by the “DefaultConnection” connection string. As I want to use only one database for the ASP.NET Universal Providers and the Commerce DB, I select the same connection string for both cases. It happens to be the Windows Azure SQL Database that was created with the Windows Azure Web Site.

La chaîne de connexion “ApplicationServices” a été remplacée par la chaîne de connexion “DefaultConnection”. Comme je veiux utiliser uniquement une base de données pour les fournisseurs universels ASP.NET et la base Commerce, je sélectionne la même chaîne de connexion pour les deux cas. Il s’agit d’ailleurs de la base Windows Azure SQL Database qui avait été créée en même temps que le site Web Windows Azure.

For both databases, I leave the Update Database check box cleared because I use other means to migrate the databases. The ASP.NET Universal Providers will create the schema at runtime, and I will migrate the Commerce DB with a tool I like a lot because it si simple and easy to use.

Pour les deux bases de données, je laisse la case à cocher “Update Database” vierge puisque j’utilise d’autres méthodes pour migrer les bases. La base des fournisseurs universels ASP.NET créera le schéma au moment de l’exécution, et je vais migrer le base de données Commerce avec un outil que j’aime bien pour sa simplicité d’utilisation.

Next>

Publish

…

Let’s now migrate the database with the Windows Azure SQL Database migration Wizard that can be found at http://sqlazuremw.codeplex.com.

Migrons maintenant la base de données avec l’assistant de migration Widnows Azure SQL Database qui peut être trouvé à http://sqlazuremw.codeplex.com.

I just download it, unblock it, and extract it to a folder from where I start SQLAzureMW.exe.

Je le télécharge, le débloque, l’extrais dans un dossier où je peux démarrer SQLAzureMW.exe.

Connect

Next>

The result summary gives information about default choices made by the tool. They can also be seen in the SQL Script tab. Here is its content in my case:

Le résumé du résultat fournit quelques informations sur les choix par défaut proposés par l’outil. On peut aussi les voir dans l’onglet “SQL Script”. Voici son contenu dans mon cas:

--~Changing index [dbo].[Orders].PK_Orders to a clustered index.  You may want to pick a different index to cluster on.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Orders]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Orders](
    [OrderID] [int] IDENTITY(1,1) NOT NULL,
    [CustomerName] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OrderDate] [datetime] NOT NULL,
    [ShipDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED 
(
    [OrderID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Orders_OrderDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Orders] ADD  CONSTRAINT [DF_Orders_OrderDate]  DEFAULT (getdate()) FOR [OrderDate]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Orders_ShipDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Orders] ADD  CONSTRAINT [DF_Orders_ShipDate]  DEFAULT (getdate()) FOR [ShipDate]
END
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderDetails]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[OrderDetails](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [OrderID] [int] NULL,
    [ProductID] [int] NULL,
    [Quantity] [int] NULL,
    [UnitCost] [money] NULL,
 CONSTRAINT [PK_OrderDetails] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
END
GO
--~Changing index [dbo].[Categories].PK_Categories to a clustered index.  You may want to pick a different index to cluster on.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Categories]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Categories](
    [CategoryID] [int] IDENTITY(1,1) NOT NULL,
    [CategoryName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_Categories] PRIMARY KEY CLUSTERED 
(
    [CategoryID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
END
GO
--~Changing index [dbo].[Products].PK_Products to a clustered index.  You may want to pick a different index to cluster on.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Products]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Products](
    [ProductID] [int] IDENTITY(1,1) NOT NULL,
    [CategoryID] [int] NOT NULL,
    [ModelNumber] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ModelName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ProductImage] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UnitCost] [money] NOT NULL,
    [Description] [nvarchar](3800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_Products] PRIMARY KEY CLUSTERED 
(
    [ProductID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
END
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SelectPurchasedWithProducts]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE dbo.SelectPurchasedWithProducts
 @ProductID int
AS
    SELECT  TOP 5 
    OrderDetails.ProductID,
    Products.ModelName,
    SUM(OrderDetails.Quantity) as TotalNum

FROM    
    OrderDetails
  INNER JOIN Products ON OrderDetails.ProductID = Products.ProductID

WHERE   OrderID IN 
(
    /* This inner query should retrieve all orders that have contained the productID */
    SELECT DISTINCT OrderID 
    FROM OrderDetails
    WHERE ProductID = @ProductID
)
AND OrderDetails.ProductID != @ProductID 

GROUP BY OrderDetails.ProductID, Products.ModelName 

ORDER BY TotalNum DESC
RETURN

' 
END
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Reviews]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Reviews](
    [ReviewID] [int] IDENTITY(1,1) NOT NULL,
    [ProductID] [int] NOT NULL,
    [CustomerName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CustomerEmail] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Rating] [int] NOT NULL,
    [Comments] [nvarchar](3850) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_Reviews] PRIMARY KEY CLUSTERED 
(
    [ReviewID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
END
GO
--~Changing index [dbo].[ShoppingCart].PK_ShoppingCart to a clustered index.  You may want to pick a different index to cluster on.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShoppingCart]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ShoppingCart](
    [RecordID] [int] IDENTITY(1,1) NOT NULL,
    [CartID] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Quantity] [int] NOT NULL,
    [ProductID] [int] NOT NULL,
    [DateCreated] [datetime] NOT NULL,
 CONSTRAINT [PK_ShoppingCart] PRIMARY KEY CLUSTERED 
(
    [RecordID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
END

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ShoppingCart]') AND name = N'IX_ShoppingCart')
CREATE NONCLUSTERED INDEX [IX_ShoppingCart] ON [dbo].[ShoppingCart] 
(
    [CartID] ASC,
    [ProductID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF)
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ShoppingCart_Quantity]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ShoppingCart] ADD  CONSTRAINT [DF_ShoppingCart_Quantity]  DEFAULT ((1)) FOR [Quantity]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ShoppingCart_DateCreated]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ShoppingCart] ADD  CONSTRAINT [DF_ShoppingCart_DateCreated]  DEFAULT (getdate()) FOR [DateCreated]
END
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[VewOrderDetails]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW dbo.VewOrderDetails
AS
SELECT        dbo.Products.ProductID, dbo.Products.ModelNumber, dbo.Products.ModelName, dbo.OrderDetails.Quantity, dbo.OrderDetails.UnitCost, 
                         dbo.OrderDetails.OrderID
FROM            dbo.OrderDetails INNER JOIN
                         dbo.Products ON dbo.OrderDetails.ProductID = dbo.Products.ProductID
' 
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[ViewAlsoPurchased]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW dbo.ViewAlsoPurchased
AS
SELECT        TOP (5) dbo.OrderDetails.ProductID, dbo.Products.ModelName, SUM(dbo.OrderDetails.Quantity) AS TotalNumPurchased, dbo.OrderDetails.OrderID, 
                         dbo.Products.ProductID AS Products_ProductID
FROM            dbo.OrderDetails INNER JOIN
                         dbo.Products ON dbo.OrderDetails.ProductID = dbo.Products.ProductID
WHERE        (dbo.OrderDetails.OrderID IN
                             (SELECT DISTINCT OrderID
                               FROM            dbo.OrderDetails AS OrderDetailsSelected))
GROUP BY dbo.OrderDetails.ProductID, dbo.Products.ModelName, dbo.OrderDetails.OrderID, dbo.Products.ProductID
ORDER BY TotalNumPurchased DESC
' 
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[ViewCart]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW dbo.ViewCart
AS
SELECT        TOP (100) PERCENT dbo.Products.ProductID, dbo.Products.ModelNumber, dbo.Products.ModelName, dbo.Products.UnitCost, dbo.ShoppingCart.Quantity, 
                         dbo.ShoppingCart.CartID
FROM            dbo.Products INNER JOIN
                         dbo.ShoppingCart ON dbo.Products.ProductID = dbo.ShoppingCart.ProductID AND dbo.Products.ProductID = dbo.ShoppingCart.ProductID
ORDER BY dbo.Products.ModelName, dbo.Products.ModelNumber
' 
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Order_OrderDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[OrderDetails]'))
ALTER TABLE [dbo].[OrderDetails]  WITH CHECK ADD  CONSTRAINT [FK_Order_OrderDetails] FOREIGN KEY([OrderID])
REFERENCES [dbo].[Orders] ([OrderID])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Order_OrderDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[OrderDetails]'))
ALTER TABLE [dbo].[OrderDetails] CHECK CONSTRAINT [FK_Order_OrderDetails]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Products_Categories]') AND parent_object_id = OBJECT_ID(N'[dbo].[Products]'))
ALTER TABLE [dbo].[Products]  WITH CHECK ADD  CONSTRAINT [FK_Products_Categories] FOREIGN KEY([CategoryID])
REFERENCES [dbo].[Categories] ([CategoryID])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Products_Categories]') AND parent_object_id = OBJECT_ID(N'[dbo].[Products]'))
ALTER TABLE [dbo].[Products] CHECK CONSTRAINT [FK_Products_Categories]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Reviews_Products]') AND parent_object_id = OBJECT_ID(N'[dbo].[Reviews]'))
ALTER TABLE [dbo].[Reviews]  WITH NOCHECK ADD  CONSTRAINT [FK_Reviews_Products] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Products] ([ProductID])
NOT FOR REPLICATION 
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Reviews_Products]') AND parent_object_id = OBJECT_ID(N'[dbo].[Reviews]'))
ALTER TABLE [dbo].[Reviews] CHECK CONSTRAINT [FK_Reviews_Products]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ShoppingCart_Products]') AND parent_object_id = OBJECT_ID(N'[dbo].[ShoppingCart]'))
ALTER TABLE [dbo].[ShoppingCart]  WITH CHECK ADD  CONSTRAINT [FK_ShoppingCart_Products] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Products] ([ProductID])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ShoppingCart_Products]') AND parent_object_id = OBJECT_ID(N'[dbo].[ShoppingCart]'))
ALTER TABLE [dbo].[ShoppingCart] CHECK CONSTRAINT [FK_ShoppingCart_Products]
GO
-- BCPArgs:2:[dbo].[Orders] in "c:\SQLAzureMW\BCPData\dbo.Orders.dat" -E -n -b 10000 -a 16384
GO
-- BCPArgs:13:[dbo].[OrderDetails] in "c:\SQLAzureMW\BCPData\dbo.OrderDetails.dat" -E -n -b 10000 -a 16384
GO
-- BCPArgs:7:[dbo].[Categories] in "c:\SQLAzureMW\BCPData\dbo.Categories.dat" -E -n -b 10000 -a 16384
GO
-- BCPArgs:41:[dbo].[Products] in "c:\SQLAzureMW\BCPData\dbo.Products.dat" -E -n -b 10000 -a 16384
GO
-- BCPArgs:6:[dbo].[ShoppingCart] in "c:\SQLAzureMW\BCPData\dbo.ShoppingCart.dat" -E -n -b 10000 -a 16384
GO

In this case, what the tool did was to make some indexes on primary keys clustered because a Windows Azure SQL Database requires each table to have a cluster index. The tool also removed extended properties(without mentionning) that are used by the entity framework to store designer related data that can be used at design time.	Dans ce cas, ce que l’outil a fait est de rendre l’index sur la clef primaire clusterisé parce qu’une base Windows Azure SQL Database a besoin d’un index custerisé. L’outil a également supprimé des propriétés étendues (sans le mentionner) qui sont utilisées par l’entity framework pour stocker des informations du designer qui peuvent être utilisées au moment de la conception.
If you need to have a deep control on how the database is migrated, you can also use the SQL Server Data Tools (SSDT). This blog post explains how this works.	Si vous avez besoin d’avoir un contrôle plus précis sur la façon dont la migration de la base se fait, vous pouvez utiliser les SQL Server Data Tools (SSDT). Ce billet explique comment cela marche.
The choices made by the tool are OK for me so I just accept and click Next and I enter the parameters about the Windows Azure SQL Database server	Les choix effectués par l’outil me conviennent donc j’accepte, je clique sur Next et j’entre les paramètres à propos du serveur Windows Azure SQL Database

18/09/2012 16:18:34 --> Error #: 40514 -- 'NOT FOR REPLICATION' is not supported in this version of SQL Server.
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Reviews_Products]') AND parent_object_id = OBJECT_ID(N'[dbo].[Reviews]'))
ALTER TABLE [dbo].[Reviews]  WITH NOCHECK ADD  CONSTRAINT [FK_Reviews_Products] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Products] ([ProductID])
NOT FOR REPLICATION

The script had remaining errors. So I change the local database with SSDT before re-executing the Wizard.

Le script a encore quelques erreurs. Cela m’amène à changer la base de données locale avec SSDT avant de ré-exécuter l’assistant.

NB: the same could also have been done from SQL Server Management Studio.

NB: on peut faire la même chose depuis SQL Server Management Studio.

I restart the Windows Azure SQL Database Migration Wizard with the same steps as before until this screen:

Je redémarre l’assistant de migration Windows Azure SQL Database avec les mêmes étapes que précédemment jusqu’à cet écran:

…

The tables that had already succeeded have primary key violations when trying again, which can be safely ignored. Another option could be to remove objects in the target database and retry. I choose to skip the errors.

Les tables qui avaient jusqu’ici déjà été migrées ont des violations de clef primaire quand l’outil cherche à recharger leurs données; cela peut donc être ignoré. Une autre option aurait été de supprimer les objets dans la base cible et de recommencer. Je choisis d’ignorer les erreurs en question.

and I repeat the operation for each tab about any previously succeeding table until the last one

puis je répète l’opération pour les différents onglets des différentes tables concernées jusqu’au dernier

the result is OK

le résultat est OK

Exit

I can now test the App in Windows Azure Web Sites:

Je peux maintenant tester l’application dans Windows Azure Web Sites:

http://tailspinspyworks.azurewebsites.net/

the pictures were not included because they are not part of the project which is a good way to show how easy it is to update the app from the Visual Studio project:

les images n’ont pas été incluses parce qu’elles ne faisaient pas partie du projet ce qui me donne l’occasion de montrer qu’il est simple de republier l’application depuis le projet Visual Studio:

After creating the first user, I see that the database contains the table for membership and so on, together with the other commerce tables; having all the tables in the same DB is the option I chose:

Après avoir créé le premier utilisateur, je vois que la base de données contient les tables d’utilisateurs entre autres, ainsi que les tables de la base commerce; avoir toutes les tables dans la même base est l’option que j’avais choisie:

Benjamin