ApexSQL Script creates insert scripts from any Microsoft® SQL Server© 7 or 2000 database that can be archived, emailed, checked into source control, run against another database etc.

Auto-Inserts handles Identity fields and can auto-sequence the scripting order of tables to avoid referential integrity violations even when re-loading an entire database.ApexSQL Script is a software that helps you to create insert scripts.

Here are some key features of "ApexSQL Script":

· Script objects too (with incredible performance) - tables, procedures etc for complete deployment solution
· Completely redesigned interface
· Tremendous performance improvements especially on large tables
· Support for all sql datatypes (including Text, Image, sql_variant etc)
· Ability to append where clause to Table/Views via interface
· Table / View aliases so you can script one table/view to a different table/view
· Column level scripting - this feature allows you to pick and choose what columns you want to include in the script
· Table/View level row limits. Now you have the option to limit the number of rows to script on an individual Table / View level
· 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.


Requirements:

· MDAC 2.6 (ADO 2.6) or greater
· Microsoft SQL Server version 7 or 2000
· Microsoft SQL DMO Object Library (SQLDMO.DLL)