I have an Azure SQL Server which I would like to dump out into a .sql file. How can I achieve this most easily, and preferably only using the provided tools? I have tried using the export functionality on the azure portal but that only seems to be for backing up the DB to another part of Azure. I need it to be a .sql dump file such that I can reconstruct this DB in postgres
Add a comment
|
1 Answer
Are you looking for something different than generating scripts with data?
This post discusses it: Script all data from SQL Server database