I wish to join another developer to my project. To maintain code versioning we're going to use Team Foundation Service. But I see some other colaboration issues:
a) Today my dev dabase is on localhost and production is on sql azure. I assume I will have to move dev DB also to azure and allow full access to the second developer. We're using dynamic IP's, so every time I want to connect to azure DB i have to enable
my IP in azure firewall. Does he need to be sql azure server admin to enable his IP every time?
b) Is it possible to allow him access to publish azure package to staging instance and restrict possibility to swap production only to me? As far as I know, the TFS can be connected to azure service to automate building and publishing. But I cannot find
any articles about access restrictions.
c) Are there any materials/books that describe best practices how team should organize it's work using Visual Studio 2010/12, TFS and Azure?
The Set Server Firewall
Rule with IP Detect operation adds a new server-level firewall rule or updates an existing server-level firewall rule for a SQL Database
server with requester’s IP address. This is useful when a user does not know his/her external IP address due to address translation, proxy servers, etc. For information on creating a server-level firewall with an IP Address range, see Creating
Server-Level Firewall Rules.