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

How to export and im port azure database in sql format ? Expand / Collapse
Author
Message
Posted Thursday, July 4, 2013 3:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 8, 2013 6:31 AM
Points: 1, Visits: 5
Hello,
I am messing up for 2 days and can't find any stuff that can help to extract azure db to .sql format for my php use...

and i can't even export or import in excel file to azure or from azure db.

Please help me is their a way to achieve my goal.



Thanks !
Post #1470378
Posted Wednesday, July 17, 2013 5:47 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 7:32 PM
Points: 15,517, Visits: 27,895
You should be able to just connect and query the database from Excel. You just use the login that lets you at the data. I've done this from Excel (and Access) and it works just fine.

As far as getting it out to .SQL format, the best advice I can give here would be to run the import/export to create a BACPAC. This can then be loaded into a local instance of SQL SErver and from there you can export out to .SQL just fine.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1474510
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse