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

  • 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 !

  • 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 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

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

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