SQL Server Azure offers scalability when it comes to storage, memory, and CPU, but I'm guessing that this website really isn't that massive and it grows over time in a predictable way. I'm guessing that your biggest concern should be how moving your websute and databases to the cloud would impact accessibility and latency. Latency; that's probably the game changer.