About Me/Legal Notice 
 Home   T-SQL Data Scripts   Export to Text/CSV   Text/CSV to SQL   Export to PDF/Excel   Command Line   Reporting Services   Download     Buy     History 


SQL Scripter is a powerful tool for Microsoft SQL Server 7.0/2000/2005/2008 database administrators and developers
to generate data scripts in a readable and executable T-SQL format.

Advertisement

Source Data
The source for your scripts could be a table, a view or your own SQL.
 
Action Type and Key Fields
The data can be scripted in several ways.
  • Just insert the records
  • Insert only new records
  • Insert new records, update existing records
  • Update only existing records
  • Insert all records, but delete first if records exists
  • Delete existing only records
Choose your own key fields, or just select from one of the indexes on the tables.
 
Options
Specify additional options, save your settings as template.
 
Advertisement
 
Result Example: Insert new records, update existing records.
 
Result Example: Generate Insert Scripts without any checks.
 
Result Example: Insert only new records.
 
Result Example: Binary fields (exp.: image data type).
 
Advertisement
 
Quick Scripter
Use Quick Scripter to generate scripts for all tables in a single step.