ApexSQL Script

Apex SQL Script is a SQL tool that creates insert scripts from any Microsoft(r) SQL Server(c) 7 or 2000 database table (or view) that can be archived, emailed, checked into source control, run against another database etc.

Apex SQL Script handles Identity fields and can auto-sequence the scripting order and even suppress constraints and triggers while batch inserting.

You can manage maximum rows, table/view names via aliases, custom where clauses and much more. Scripting is granular down to field level giving you complete control of what tables/views and fields to script.

Coming Soon

Batch / Command Line interface
Tons more smaller features

Features

[NEW] Script objects too (with incredible performance) - tables, procedures etc for complete deployment solution
[NEW] Completely redesigned interface
[NEW] Tremendous performance improvements especially on large tables
[NEW] Support for all sql datatypes (including Text, Image, sql_variant etc)
[NEW] Ability to append where clause to Table/Views via interface
[NEW] Table / View aliases so you can script one table/view to a different table/view
[NEW] Column level scripting - this feature allows you to pick and choose what columns you want to include in the script
[NEW] Table/View level row limits. Now you have the option to limit the number of rows to script on an individual Table / View level
[NEW] Allows you to suppress All Constraints and/or Triggers prior to running scripts
Handles Identity fields to either increment or copy the exact values using the SQL Identity_Insert command.
Auto sequencing of tables based on system table reference data allows data to be removed and then inserted again in reverse order to allow processing of insert scripts even while referential integrity is still being enforced.
Option to Add custom comments to sql file and as each table is processed.
Option to allow Print statements to be added to sql script.
Option to Delete all records from each table prior to processing inserts.
Option to script only n rows for each table.
Frequency of transaction commits is variable and can be set to every n number of rows.
Ability to save and retrieve Table Order profiles for each database.

Awards

What people are saying ...

"[Apex SQL Script] is a nifty, easy to use utility ..."

Brad M. McGehee
SQL-Server-Performance

"Great tool - we use [Apex SQL Script] for every production build at our company and it is a key component of our build process."

Brian Knight
SQLServerCentral

"I found the tool [Apex SQL Script] perfect for the job I needed to carry out. Thanks for making me look like a star!"

Troy Magennis
Ionos.com

Screenshots

Script Objects

Script Data

Results of Data Scripting

Results of Object Scripting

Customer Comment

"I congratulate you on the decision and the approach of free upgrades for life as it is a rare opportunity to see that these days, when most other software companies want more and more money for the things we as users already paid for. I think that if you believe in your product it will speak for itself"

Vilko Poznovia
Database Administrator
Silver Chain
Perth, Western Australia

Order

We are a leading provider of value SQL tools for Microsoft SQL Server developers

Single Developer License - for only one SQL Server databases Developer

Site Developer License - for many SQL Server databases Developers

Additional Information: Apex SQL Script

License

Price

Secure Order

OS : Windows XP/2000/Me/98/NT

Free Upgrades and support for life

Single Developer

$195

Buy Online

Site

$199

Buy Online

Home More Software More Apex Sql Products

More Software

Excel Spreadsheets