How can I export a SQL Server database in *.sql format?

Question

The system I am working on needs to create data dumps in SQL format. Is there a built-in way (like the mysqldump tool) to create this with SQL Server?
I am working specifically with Azure SQL Edge in a container on a Mac or on Linux.
This is not a production system, no need to be super performant.

If this is not possible, is there any other simple way to share small pieces of my database, as files?

The desired result of such a dump would be a simple text file (not CSV, nor *.bak or similar)

insert into table a.A
values
(v,v,v,v,v),
(v,v,v,v,v),
....
....
....
(v,v,v,v,v);

insert into table a.b
values
(v,v,v,v,v),
(v,v,v,v,v),
....
....
....
(v,v,v,v,v);

One of the purposes is educational, which is why readable SQL format is preferable.

Does this answer your question? [mysqldump equivalent for SQL Server](https://stackoverflow.com/questions/85186/mysqldump-equivalent-for-sql-server) — Thom A, Dec 30 '22 at 19:32
Check this once https://blog.devart.com/how-to-export-and-import-sql-server-database-data-to-a-sql-script.html — Bhavani, Dec 30 '22 at 20:18
Does [this](https://stackoverflow.com/questions/15735722/get-sql-file-from-sql-server-2012-database) answer your question? — tink, Dec 30 '22 at 22:02

score 0 · Accepted Answer · answered Jan 01 '23 at 20:06

0

All suggestions redirect you to installing SSMS and creating a .sql file but if I'm not wrong you are using MacOS or Linux.

In this case I suggest you to install DbVisualizer which is available for MacOS or Linux and do the same thing.

answered Jan 01 '23 at 20:06

Francesco Mantovani

10,216
13
73
113

How can I export a SQL Server database in *.sql format?

1 Answers1