Copy SQLAzure DB from cloud to local

Question

Copy SQLAzure DB from cloud to local

BSavoie

SSCertifiable

Points: 6309
More actions
November 16, 2010 at 12:47 pm

#242908

I 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!
.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

there 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

http://sqlazuremw.codeplex.com/

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

BSavoie SSCertifiable Points: 6309 More actions · Answer 2

Right. 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.

.

BSavoie SSCertifiable Points: 6309 More actions · Answer 3

Just 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/

.