Hi, we are implemented our instance of Sitecore primarily in the cloud. We have Azure VMs running Sitecore with the Sitecore DB's also in the cloud using Azure SQl. Using SQL Server Management Studio 2014 I was easily able to push the web, core and master databases to Azure. However when I tried to move the sessions database it failed. It appears that Azure SQL server does not support what the CreateTables stored procedure is doing. I was able to finally get the sessions databse up to Azure SQL but I had to delete the CreateTables stored procedure first.
So I actually have two questions:
1. Does anyone know of a way to re-write the stored procedure that makes it more compatible with Azure SQL?
2. Or if that is not possible what would be the impact if I simply did not use that stored procedure?