I've been using VS11 beta, which comes with SQL Server 2012. I also have a SQL Server 2008 R2 version of the .mdf file because the staging server uses R2.
I'll later be porting the project to SQL Azure. If I start making changes to the DB structure of the SQL Server 2012 version of the file, will it be possible to later convert it to SQL Azure later or do I need to make the changes to the R2 .mdf file as well to keep it in sync?
Thanks.
SQL Azure is built on top of SQL Server 2012. You can use the SQL Azure Migration Wizard to directly migrate a SQL Server 2012 database to SQL Azure.