This extension provides a quick and easy way to migrate data between tables by generating insert scripts based on the result sets of a query. It defaults to generating all data from a given table (based on the table selected via a context menu), but the default sql can be modifed to generate subsets of data.
The current release is available to download as a .vsix file and can be installed by opening the File Menu and selecting Install Extension from VSIX Package
Right-click on a Table or View node to bring up a [Script Table Data] context menu. An input box will open showing the default SQL of selecting all data. You can simply press [Enter] to accept the default or the SQL using a WHERE clause, joins on other tables, etc... Any valid SQL is acceptable. Press [Enter] to run the query.
The data will be scripted to a new SQL Editor window.
- This has only been tested with the MSSQL provider, i.e. Microsoft SQL Server.
Can be raised here: https://github.com/ecirpnaes/SimpleDataScripter/issues
Can be found here: https://raw.githubusercontent.com/ecirpnaes/SimpleDataScripter/master/CHANGELOG.md