Write SQL select statements and generate insert statements to populate another database table.
This application is a stand alone executable which must be placed on the same server as the MS SQL Server database instance. It will only work with the default instance, named instances aren't supported as yet.
All that needs to be done is to write your SELECT * FROM statement with as many AND clauses as required and then click Generate to output the insert statements to the desktop.
SQL Server doesn't have anything like this so I wrote this to export and import data for testing on a test database.
I hope you find it useful, please let me know what you think.
Operating systems:
Windows 7, Windows 8, Windows Vista, Windows 2003, Windows Server 2008
Additional requirements:
.Net Framework 4.0 or later
Date:
03.02.2014
Related Software