Which ways do I have to import my tables and data from SQL Server to SQL Azure?

Question

I'm looking for the easiest way to import data from SQL Server to SQL Azure.

I'd like to work locally, would there be a way to synchronize my local database to SQL Azure all the time?

The thing is I wouldn't like to update each time I add a table in my local database to SQL Azure.

Answer 1

I HIGHLY recommend using the SQL Database Migration Wizard: http://sqlazuremw.codeplex.com/ it is the best free tool I've used so far. Simple and works much easier the the SSMS and VS built in tools. I think the Red-Gate tools now work well with SQL Azure too - but I haven't had a chance to use them.