SQL Object Scripter

SQL Object Scripter will write an XML File with attributes from your SQL Server 2005 database. This XML file can be imported into this program to sync the objects in another database. The program will allow you to add columns or change column default values in a development environment, export an xml file and push the changes to a database in production without the loss of data.

It will also script views, Stored Procedures, and Functions. It uses the SQL Server 2005 Dependency detection to sort the tables and views in order for creation. This tool also allows you to pick and choose which objects to export as well as which objects to synchronize from the XML file. Version 1.2 adds features that show how many objects are selected at a given time. Also now it is possible to sort everything alphabetically while still scripting and synchronizing in order of dependency. This makes objects easier to find while still allowing them to be created in the correct order.