search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.58k stars 906 forks source link

Save query resultset as INSERT statements #459

Open bulesky520 opened 6 years ago

bulesky520 commented 6 years ago

Steps to Reproduce: How to Save as Script from Result gird，like this pic? image

kburtram commented 6 years ago

@bulesky520 we don't currently support this, but I like the feature suggestion. We'll put this issue on the backlog for future consideration. Thanks!

kburtram commented 6 years ago

Please look at issue https://github.com/Microsoft/sqlopsstudio/issues/499 for the Script as Insert from OE context menu related suggestion.

kburtram commented 6 years ago

Please look at issue https://github.com/Microsoft/sqlopsstudio/issues/1277 for additional requirements when fixing this.

dheerajps commented 5 years ago

Any update on the status of this? Would really help us, we are using Flyway for DB migration and for inserting test-data, script as insert would come in really handy. Something we miss from SSMS world.

Ruud-cb commented 4 years ago

Would like to see this as well, any extension available that can do this? I've used this workaround to get things done, it's not perfect but saves some time for sure: https://stackoverflow.com/a/982587/2901207