InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 19:12:40 GMT20http://www.sqlservercentral.com/Forums/Topic1021752-2572-1.aspxJust thought I'd let everyone know that the Sql Azure Migration Wizard is awesome. I've used it many times now. There is a setting that specifies if data should be migrated along with the schema. I don't think I had that set the first time. I've also been using the trial version of the RedGate stuff (SQL Compare/SQL Data Compare). It works well too, but honestly I like the SAMW a little better AND it's free! The RedGate stuff is much better at comparing schemas and data though for sure, but for just moving DB's around, particularly on Azure. SAMW is the BOMB.http://sqlazuremw.codeplex.com/Sat, 11 Dec 2010 22:20:19 GMTBSavoiehttp://www.sqlservercentral.com/Forums/Topic1021752-2572-1.aspxRight. I should have mentioned that I tried that, and it pulls down the schema just fine, but I can't get it to pull down any data. I set the option to pull schema AND data, but it seems to ignore the data. Maybe I should try and find a forum for that tool instead.Tue, 16 Nov 2010 12:54:02 GMTBSavoiehttp://www.sqlservercentral.com/Forums/Topic1021752-2572-1.aspxthere is a project on codeplex to help do this kind of thing in either direction; i downloaded it but did not test it yet, but it might help you out:1.SQL Server to SQL Azure 2.SQL Azure to SQL Server 3.SQL Azure to SQL Azure[b][url]http://sqlazuremw.codeplex.com/[/url][/b]Tue, 16 Nov 2010 12:50:30 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1021752-2572-1.aspxI need to pull down a SQLAzure DB from cloud storage to my local sql server instance. I need to get both schema and data. What's my best bet? SSIS? If so which task is most well sutied?Thanks!Tue, 16 Nov 2010 12:47:00 GMTBSavoie