Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Copy SQLAzure DB from cloud to local Expand / Collapse
Author
Message
Posted Tuesday, November 16, 2010 12:47 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 25, 2014 3:40 PM
Points: 309, Visits: 729
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!


.
Post #1021752
Posted Tuesday, November 16, 2010 12:50 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:39 PM
Points: 12,903, Visits: 32,143
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1021753
Posted Tuesday, November 16, 2010 12:54 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 25, 2014 3:40 PM
Points: 309, Visits: 729
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.

.
Post #1021757
Posted Saturday, December 11, 2010 10:20 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 25, 2014 3:40 PM
Points: 309, Visits: 729
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/


.
Post #1033424
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse