Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Copy SQLAzure DB from cloud to local


Copy SQLAzure DB from cloud to local

Author
Message
BSavoie
BSavoie
Old Hand
Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)

Group: General Forum Members
Points: 327 Visits: 788
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!

.
Lowell
Lowell
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14959 Visits: 38977
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
BSavoie
Old Hand
Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)

Group: General Forum Members
Points: 327 Visits: 788
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
BSavoie
Old Hand
Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)

Group: General Forum Members
Points: 327 Visits: 788
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/

.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search