amScript


Current component version: 1.2008.2.2
Document revision: January, 16th 2009
This tool provides a way to generate DDL Transact-SQL statements to re-create objects identical to those currently available in the selected database. The feature can be handy when you want to distribute database schema via script and not via a detached database or for maintaining database schema under Source Code control with tools like Microsoft Source Safe.

You can select the object you want to script, filtering in several ways the object type's..
Dependent objects flavour is also included, providing a way to get a complete runnable script for the piece of database schema you want to generate.

The output can be generated in the provided preview pane, as well as directly to the file system, where you can specify a unique output file or a separate file for each object.

A separate non modal dialog can show the dependency chain(s) for the selected objects, in both directions, thus showing the objects depending on the selected objects (Parent dependency tree) or the objects the selected objects depend on (Child dependency tree).

Scripts based on non hierarchical format (Dependent objects = false) are written in a "top-down" way, starting with:

  • Schemas
  • Assemblies
  • PartitionFunctions
  • PartitionSchemes
  • Synonyms
  • XmlSchemaCollections
  • UserDefinedDataTypes
  • CLR based UserDefinedTypes
  • UserDefinedAggregates
  • Rules
  • Defaults
  • User Tables
  • Views
  • Stored Procedures
  • User Functions

    In both scripting modes (dependency tree based and not), all relative dependent objects are then scripted, if specified, like:
  • Indexes and Primary keys on user tables
  • Indexes and Primary keys on views
  • FullText indexes on user tables
  • Trigger on user tables
  • Trigger on views
  • Default constraints
  • Check constraints
  • Foreign keys constraints on user tables
  • Foreign keys constraints on views
  • Extended properties
  • Permissions
  • Database triggers

    Settings of particular database(s) definition can be saved to workspace(s) to be later retrieved, modified and executed; (critical connection information are not stored in the workspace file in order to allor easy migration to different servers).

    Dependencies:
  • Microsoft .Net framework 3.5 sp1
  • Windows Installer 3.1
  • MSXML6 Microsoft Core XML Services (MSXML) 6.0
  • SQL Native Client
  • Microsoft SQL Server 2005 Management Objects Collection

    Please verify and check the produced script(s), as Microsoft SMO component seems not to be very smart in some circumstances.

    The project is free to use.

    The tool is provided with an installer programm, but can be installed on computer hosting SQL Server 2008 (all editions) binaries in XCopy mode (where no additional SMO related dlls are provided).
    The installer .MSI package does not include the required dependencies but 2 additional SMO related dlls that are provided.

    amScript can only connect to and work against SQL Server 2005 and SQL Server 2008 instances.

     

    Additional and/or alternate source of all Microsoft SQL Server downloads can be directly found at the Microsoft SQL Server Download Center.


    At this link, you can find additional Microsoft released tools/components for SQL Server Express as well, including SQL Server Management Studio Express.

    Please do not hesitate to report bugs, errors and/or suggestions.
    Check for new releases as long as for further tools..

    Copyright (C) 2009 Andrea Montanari - Insulin Power