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%u00e9ation de nouveaux sites Web. Un tel site peut %u00eatre vide, cr%u00e9%u00e9 %u00e0 partir d’un Framework populaire tel que WordPress ou Umbraco, ou %u00eatre le r%u00e9sultat 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%u00e9s par vous m%u00eame, vous pouvez profiter d’une offre d’essai gratuit pendant 90 jours, et activer la fonctionnalit%u00e9 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 %u00e9crit beaucoup %u00e0 propos d’ASP.NET MVC qui est excellent, mais les applications existantes risquent fort d’%u00eatre de type Web Forms ASP.NET (NB: une bonne partie de ce billet s’applique %u00e0 ASP.NET en g%u00e9n%u00e9ral et donc %u00e0 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%u00e9f%u00e9rence d’ASP.NET. On peut le trouver %u00e0 http://www.asp.net/web-forms/samples qui am%u00e8ne au site de t%u00e9l%u00e9chargement 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%u00e8re partie de ce billet est consacr%u00e9e %u00e0 la fa%u00e7on de t%u00e9l%u00e9charger 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%u00e9veloppement a Visual Studio 2012, SQL Server 2012, et les derniers outils SQL Server Data Tools (SSDT) qui peuvent %u00eatre t%u00e9l%u00e9charg%u00e9s 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 %u00e9t%u00e9 %u00e9crite avec la g%u00e9n%u00e9ration pr%u00e9c%u00e9dente 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%u00e8s avoir d%u00e9bloqu%u00e9 le fichier zip que j’ai t%u00e9l%u00e9charg%u00e9 depuis codeplex et d%u00e9zipp%u00e9 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%u00e9es diff%u00e9rentes. La base ASP.NET et la base Commerce. La premi%u00e8re contient des services ASP.NET telle que les comptes et la base commerce contient les donn%u00e9es 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%u00e9es supposent l’utilisation de SQL server Express. Dans mon cas, j’ai SQL Server 2012 developer edition; je d%u00e9place donc les fichiers depuis App_Data du projet pour les attacher %u00e0 cette instance SQL Server 2012 developer edition. Les d%u00e9tails exacts vont au del%u00e0 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%u00e8ve %u00e9galement l’utilisateur qui correspond au d%u00e9veloppeur puisqu’il n’est pas utilis%u00e9 dans ce projet. Il y a %u00e9galement un sch%u00e9ma associ%u00e9 qui n’est pas non plus utilis%u00e9 et que je supprime %u00e9galement.
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%u00eames bases de donn%u00e9es depuis SSDT, de fa%u00e7on %u00e0 obtenir les cha%u00eenes 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%u00eenes de connexion locale peuvent %u00eatre mises %u00e0 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>

to 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%u00e9marrer 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%u00fb 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%u00e9er un %u00e9venement vide pour la page ProductDetails.aspx. L’%u00e9v%u00e9nement %u00e9tait absent et g%u00e9n%u00e9rait 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’%u00e0 pr%u00e9sent j’ai juste fait fonctionner l’application sur ma machine. Je n’ai pas encore commenc%u00e9 la migration vers Windows Azure! Je marque donc le billet d’un <hr/>

OK, let’s start the migration now! OK, d%u00e9marrons 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%u00e9e un nouveau site Web Windows Azure appel%u00e9 TailspinSpyworks, avec une base de donn%u00e9es Windows Azure SQL Database. Ici, je cr%u00e9e une base dans un serveur Windows Azure SQL Database existant, mais j’aurais aussi pu cr%u00e9er un nouveau serveur.
This is done from the Windows Azure portal, at http://manage.windowsazure.com. Cela se fait depuis le portail Windows Azure, %u00e0 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%u00e8s, j’ai un site Web vide avec une base de donn%u00e9es Windows Azure SQL Database associ%u00e9e o%u00f9 je vais pouvoir h%u00e9berg%u00e9e l’application migr%u00e9e.

I will get and download from the portal the publishing profile of the new web site. Je vais r%u00e9cup%u00e9rer et t%u00e9l%u00e9charger depuis le portail le profil de publication du nouveau site Web.

Now, I can start publishing from Visual Studio 2012. Maintenant, je peux d%u00e9marrer une publication depuis Visual Studio 2012.

The next screen is the most important one L’%u00e9cran 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%u00e9lectionne “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%u00e9faut une fois que l’application aura %u00e9t%u00e9 d%u00e9ploy%u00e9e.

 

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%u00e9ma de la premi%u00e8re base (ASPNETDB) peut %u00eatre recr%u00e9%u00e9 au moment de l’ex%u00e9cution dans Windows Azure SQL Database plut%u00f4t que de migrer la base. Vous trouverez plus d’information dans ce billet de Scott Handelman %u00e0 propos des fournisseurs universels ASP.NET qui sont compatibles avec Windows Azure SQL Database. Bien s%u00fbr, 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%u00e9tails sont fournis dans le lien. Je vais cr%u00e9er un utilisateur de l’application une fois que cette derni%u00e8re sera h%u00e9berg%u00e9e dans Windows Azure. Avan%u00e7ons et red%u00e9marrons 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%u00eene de connexion “ApplicationServices” a %u00e9t%u00e9 remplac%u00e9e par la cha%u00eene de connexion “DefaultConnection”. Comme je veiux utiliser uniquement une base de donn%u00e9es pour les fournisseurs universels ASP.NET et la base Commerce, je s%u00e9lectionne la m%u00eame cha%u00eene de connexion pour les deux cas. Il s’agit d’ailleurs de la base Windows Azure SQL Database qui avait %u00e9t%u00e9 cr%u00e9%u00e9e en m%u00eame 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%u00e9es, je laisse la case %u00e0 cocher “Update Database” vierge puisque j’utilise d’autres m%u00e9thodes pour migrer les bases. La base des fournisseurs universels ASP.NET cr%u00e9era le sch%u00e9ma au moment de l’ex%u00e9cution, et je vais migrer le base de donn%u00e9es Commerce avec un outil que j’aime bien pour sa simplicit%u00e9 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%u00e9es avec l’assistant de migration Widnows Azure SQL Database qui peut %u00eatre trouv%u00e9 %u00e0 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%u00e9l%u00e9charge, le d%u00e9bloque, l’extrais dans un dossier o%u00f9 je peux d%u00e9marrer SQLAzureMW.exe.

Connect

Next>

Next>

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%u00e9sum%u00e9 du r%u00e9sultat fournit quelques informations sur les choix par d%u00e9faut propos%u00e9s 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%u00e9 parce qu’une base Windows Azure SQL Database a besoin d’un index custeris%u00e9. L’outil a %u00e9galement supprim%u00e9 des propri%u00e9t%u00e9s %u00e9tendues (sans le mentionner) qui sont utilis%u00e9es par l’entity framework pour stocker des informations du designer qui peuvent %u00eatre utilis%u00e9es 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%u00f4le plus pr%u00e9cis sur la fa%u00e7on 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%u00e9s par l’outil me conviennent donc j’accepte, je clique sur Next et j’entre les param%u00e8tres %u00e0 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%u00e8ne %u00e0 changer la base de donn%u00e9es locale avec SSDT avant de r%u00e9-ex%u00e9cuter l’assistant.

 

NB: the same could also have been done from SQL Server Management Studio. NB: on peut faire la m%u00eame 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%u00e9marre l’assistant de migration Windows Azure SQL Database avec les m%u00eames %u00e9tapes que pr%u00e9c%u00e9demment jusqu’%u00e0 cet %u00e9cran:

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%u00e9j%u00e0 %u00e9t%u00e9 migr%u00e9es ont des violations de clef primaire quand l’outil cherche %u00e0 recharger leurs donn%u00e9es; cela peut donc %u00eatre ignor%u00e9. Une autre option aurait %u00e9t%u00e9 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%u00e9p%u00e8te l’op%u00e9ration pour les diff%u00e9rents onglets des diff%u00e9rentes tables concern%u00e9es jusqu’au dernier
the result is OK le r%u00e9sultat 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 %u00e9t%u00e9 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%u00e8s avoir cr%u00e9%u00e9 le premier utilisateur, je vois que la base de donn%u00e9es contient les tables d’utilisateurs entre autres, ainsi que les tables de la base commerce; avoir toutes les tables dans la m%u00eame base est l’option que j’avais choisie:

 

Benjamin

Blog Post by: Benjamin GUINEBERTIERE