Simple Data Scripter

A simple data scripting extension

Previously, we covered several ways to copy a table between two servers using a Simple Dataflow PowerShell script and an ADS extension. These examples require that both the source and destination servers be connected to Azure Data Studio (i.e., network-accessible).

However, there are times when you may want to copy data between database servers that are not directly accessible from your computer or broader network. One technique to navigate this obstacle is to script table data into one or more SQL INSERT statements. This is a long-standing feature of SQL Server Management Studio, but it is missing from Azure Data Studio, at least at the time of this writing. For these situations, you can use the Simple Data Scripter extension for ADS.

Like our previous example, to install, click on the Extensions icon in the Activity Bar and then type “scripter” in the search textbox. You should see the Simple Data Scripter extension appear below the search textbox. Click on the install button, and you’ll be redirected to this extension’s GitHub site. From GitHub, click on the simple-data-scripter-0.1.6.vsix (or later) link, as shown below: