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

• ankit 70415

  SSC Rookie

  Points: 41

  More actions

  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 !

• Grant Fritchey

  SSC Guru

  Points: 399047

  More actions

  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