Post reply

How to export and im port azure database in sql format ?

  • July 4, 2013 at 3:57 am

    #279486

    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 !

  • July 17, 2013 at 5:47 am

    #1633190

    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

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

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