I have an Azure Cloud Service that hits an Azure SQL Server. When I first set this up, I really didn't know much about what I was doing and just wanted to get familiar with Azure. So now I'm at the spot where I want to take what I have and turn it into a solid deployment structure. Assuming what I have is Prod for now, let's say I am going to create a Dev and Test instance.
The way I understand it, I should simply create 2 additional sets of Cloud Services/SQL Servers for Dev and Test respectively.
So here are my questions, still being a bit of a novice:
1) If I do this, do I create additional Azure projects within my solution to represent each environment, or are they separate configurations within the same Azure Project? Or neither?
2) What would be the best way to handle the different connection strings?