Guidelines

When moving to Windows Azure, it is important to keep in mind that there are certain guidelines and limitations. The following table shows a detailed description:

Guideline	Description
Drivers, libraries, and protocols	The following drivers and protocols can be used: .NET data provider for SQL Server from the .NET 3.5 framework SP1 or later Entity Framework, .NET 3.5 SP1 or later SQL Server 2008 R2 Native Client ODBC driver SQL Server 2008 Driver for PHP Version 1.1 or later SQL Server JDBC Driver 3.0 Only TCP/IP connections Only port 1433
Migration	SSIS and the bulk copy utility (bcp.exe) can be used together with the SqlBulkCopy class and general INSERT scripts. RESTORE and attaching to a database is not supported.
SQL agents and jobs	SQL Database does not support agents and/or jobs.
Transactions	Opening multiple connections to different databases and using them within a TransactionScope class is not supported.
Database sizes	Every SQL Azure server can contain 149 databases...