Migrating from "Linq to SQL" to SQL Azure

Question

I want to migrate an existing application from "Linq to SQL" to SQL Azure. The application is local, what i assume is that i will only have to change the connection string and the application will be connected to the cloud instead of local database and no change is required at code level.

Answer 1

If you already have your database migrated to SQL Azure, then yes all you will need to do is change the connection string and open the SQL Azrure firewall to allow your clients to access the DB (this you can do in the portal).

However, while SQL Azure is very close to SQL Server, it isn't exactly the same. Lots of links to official variations can be found on msdn: http://msdn.microsoft.com/en-us/library/ee336241.aspx or you can try running the SQL Azure Migration Wizard http://sqlazuremw.codeplex.com/