To facilitate user migration from SQLServer to SQLAzure, Microsoft released a migration tool on CodePlex. If possible, the SQLAzure migration wizard detects and corrects the incompatibility between SQLServer20052008 and SQLAzure. Some common problems that can be fixed by the wizard are: replacing the text column with varChar (max ),
To facilitate user migration from SQL Server to SQL Azure, Microsoft released a migration tool on CodePlex. If possible, the SQL Azure migration wizard detects and corrects the incompatibility between SQL Server 2005/2008 and SQL Azure. Some common problems that can be fixed by the wizard are: replacing the text column with varChar (max ),
To facilitate user migration from SQL Server to SQL Azure, Microsoft released a migration tool on CodePlex. If possible, the SQL Azure migration wizard detects and corrects the incompatibility between SQL Server 2005/2008 and SQL Azure.
Common problems that can be fixed by this wizard include replacing the text column with varChar (max) and converting user-defined types to the base type. Because SQL Azure lacks support for hierarchyID, it must be done manually. In addition to generating scripts on SQL Azure to deploy the schema for migration, you can also use this tool to migrate table data through BCP.
Figure SQL Azure LOGO
Windows Azure is the advance team for Microsoft to enter the cloud computing market. It consists of several components, including a data storage engine called SQL Azure. SQL Azure is based on a relational model that provides complete support for constraints, transactions, temporary tables, and stored procedures. Developers can access SQL Azure through ADO. NET, ODBC, or PHP.
SQL Azure is built on SQL Server 2008, and its compatibility level reaches 100. Databases running at a lower compatibility level such as 80 or 90 may have problems. Although the migration tool can capture compatibility issues, we strongly recommend that you increase the database Compatibility Level to 100 before using the tool.
The SQL Azure migration wizard beta is located on CodePlex and is based on Microsoft Public License.
The Microsoft SQL Azure Development Team released the SQL Azure CTP edition in March. In this version update, we not only saw a lot of important feature support and improvements, but also obtained a relatively complete feature set in this version. The following is a major update of SQL Azure CTP:
Firewall support
The new feature allows you to specify a detailed IP address list, which allows you to access SQL Azure Server more securely and conveniently. Cloud database security has been a concern for a long time. With the help of this function, you can precisely control and filter the hosts accessing the database.
Batch embedding support
In practice, the speed of uploading and loading data is always a headache. Therefore, the batch embedding feature was added to the SQL Azure CTP version released in October. This will greatly improve the speed of loading data, which can be said to be an increase of magnitude. You can use the SqlBulkCopy class under ADO. Net to modify and implement this function.
Database Version Selection
You can select the SQL Azure database version during the creation process. The Web version is about 1 GB, and the commercial version is about 10 GB. The same applies when creating a T-SQL, for example, the T-SQL command for creating a business database is:
Create database foo (MAXSIZE = 10 GB)
It is reported that the SQL Azure development team will provide SQL Server Driver updates for PHP 1.1 later. It also provides support for PHP 5.3, including improved usage performance and enhanced functionality. Microsoft plans to provide a more comprehensive SQL Azure version at the PDC (Professional Developer Conference) conference held in November.