SQL Scripter
Welcome to SQL Scripter - The data export and scripting utility for Microsoft SQL Server
Installing Instructions       Export Data to Text/CSV file
Generate T-SQL Data Scripts       Guarantee
Quick Scripter       Download Reporting Services files
Script from template       Version/Limitation
Create Reports - Export to PDF/Excel       FAQ / Error Messages


  Installing Instructions
SQL Scripter is written in VB.NET 2005, so it requires an installed .NET Framework (Version 2.0 or higher) on your client PC.
You can check to see if you already have the .NET Framework installed by clicking Start on your Windows desktop, selecting Control Panel, and then double-clicking the Add or Remove Programs icon. When that window appears, scroll through the list of applications. If you see Microsoft .NET Framework 2.0 listed, the required version is already installed and you do not need to install it again.
  1. If there's no .NET Framework installed, you have to install it to run SQL Scripter.
    You can do this via Windows Update, or download the framework for your OS direct from Microsoft.
  2. Download and copy the file SQL-Scripter.exe and SQL-Scripter.exe.config into a folder of your choice, there are no more setup steps needed. Just run the file.
  3. In order to use the report engine (including export to PDF/Excel), you have to install Microsoft Report Viewer first.
    Download Microsoft Report Viewer


  Generate T-SQL Data Scripts
1. SQL Scripter is able to script your data in a valid T-SQL format which can be executed in Query Analyzer or SQL Server Management Studio.

Feature list

  1. Choose your source:
    From table, view or your own SQL statement.
  2. Choose your fields.
  3. Choose between different types:
    • 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
  4. Choose your own key fields, or just select one of the existing indexes.
  5. A result file with all your data will be created.
  6. Save your settings to a template file for easy reusing it later.


  Quick Scripter
There are two types of Quick Scripter:

1. Generate T-SQL output scripts for all tables/fields in your database in a single step. The primary key is used to identify the records in each table.

2. Text/CSV Exporter. Export data to text/csv files in a single step. By default, the local date and number format will be used. "\" will be used as an escape character.


  Script From Template
This tool creates multiple output scripts in a single step using one or more previously created templates.

What are template files?
A template file contains all information necessary to generate the output scripts. For example the template file specifies the data source (Table, View, SQL), the field list, the key fields, the action type (Insert, Update, ...), the destination file name, etc. After creating template files using SQL Scripter, you can use this tool to execute one or more of these template files in a specified order.

How do I create template files?
Run SQL Scripter and follow the steps to specify all the information necessary. In step 5 ("Settings + Go") click the "Save As Template" button to save your settings to a template file. You can then use this template file with this tool.


  Export Data to Text/CSV file
Use SQL Scripter to export your data to text/csv files. Make use of different data sources, individual settings and data format options.


  Create Reports - Export to PDF/Excel
This tool can be used to create reports using Microsoft Report Viewer. Export generated reports to portable document format (pdf) or Excel (xls). See Installing Instructions for prerequisites.


  Reporting Services Files
This tool can be used to download all report files from a Reporting Services database in a single step. RDL, GIF and JPG files are supported. To read more about Reporting Services for SQL Server, click here.

There're several benefits using SQL Scripter to download/backup your reporting services files.
  • The source is always a reporting services database. This could be the current version, or just a backup.
  • There's no need to setup a full reporting services web environment to access the reports.
  • Trying to use the web default environment to backup your files will result in endless clicks.


  Version/Limitation
SQL-Scripter is shareware. Test and evaluate SQL-Scripter with full functionality.
(Only processed records will be limited).


  Terms of use
The application is developed and tested with best intention, but the author assumes no responsibility for any adverse effects of using this software.

Use the software and the result scripts on your own risk.


  FAQ / Error Messages
Error Message:
Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Answer: This is a normal behaviour of .NET Framework. Do not run SQL-Scripter from a network drive, run SQL-Scripter from your local machine (or change .NET security settings).
Error Message:
Application could not be initialized (0xc0000....). Click OK to close the application.
Answer: .NET Framework is not installed. See Installing Instructions
Quick Scripter (No Primary Key):
Question: My table has no primary key?
Answer: The primary key is used to identify the records in each table. You may have unique indexes, but non of them is indicated as 'primary key'.
Check yourself for a primary key using:
SELECT OBJECTPROPERTY(OBJECT_ID('InsertYourTableNameHere'), 'TableHasPrimaryKey')
If a primary key is available, this command returns 1.
SQL Server client tools required?
Question: Are SQL Server client tools (or any other third party object modell) required to run SQL-Scripter?
Answer: No. SQL-Scripter uses only functionality provided by .NET Framework.
Microsoft Report Viewer installed?
Question: How to check if Microsoft Report Viewer is already installed?
Answer: Use Windows Explorer to open the assembly folder (located in Windows\assembly, for instance C:\Windows\assembly). When the list appears, scroll through the list of installed assemblies. If you see Microsoft.ReportViewer.WinForms listed, the required version is already installed and you do not need to install it again.
Microsoft Excel installation required?
Question: Does xls export require Excel to be installed?
Answer: No. The xls export feature is independent of Excel. Excel is only required to view the xls file.
Adobe license required?
Question: Does PDF export require an Adobe license?
Answer: No. The ReportViewer control does not use any Adobe code to generate PDF files. PDF is an open format, and anyone can create PDF files without requiring a special license.
SQL Server versions
Question: Which SQL Server versions are supported?
Answer: SQL Server 7.0, 2000, 2005, 2008