Did you know that we can integrate our database with SQL Azure? W will use the SQLAzureMW tool that is the Azure plugin for migrating database from our local database to the azure cloud.
Windows Azure SQL Database does not support all the features and data types found in SQL Server. However, Analysis Services, Replication, and Service Broker are not currently provided in the Azure Platform.
Windows Azure SQL Database performs physical administration and any statements and options that attempt to directly manipulate physical resources will be blocked like the Resource Governor, file group references, and some physical server DDL statements. It is also not possible to set server options and SQL trace flags or use the SQL Server profiler, etc.
Initially, we generate SQL scripts but we’ll have a lot of problems with it. So in this post we resolve an ew way to generate the replica of the database on SQL Azure.
Read the rest of the article here:Â http://www.codeproject.com/Articles/744193/Database-Integration-With-SQL-Azure