ScriptSplitter Split T-SQL Script Into One File Per Object (SQL Server 2005)
Download

ScriptSplitter Ranking & Summary

ScriptSplitter Tags

split splitter SQL script SQL script executer run SQL script SQL Server Script generate T-SQL script T-SQL sql creation script create SQL script SQL script editor SQL-DMO object make SQL script T-SQL script generator SQL Object generate SQL script insert SQL script SQL script generator edit SQL script SQL Script creator convert SQL script SQL script converter Split SQL File manage SQL object Split Script Script Splitter T-SQL Script SQL Server object SQL script runner sql server 2005 sql 2005

ScriptSplitter Description

The ScriptSplitter application was developed to be a small tool which creates one file per object based on split and name criteria. This is a console application that splits a script based on a "split expression". It tries to compensate for the lost feature from SQL Server 2000 which allowed one file per object when generating a database script. After creating all of the stored procedures for the project I was in, it was time to put them all on source control. It should have been done earlier, but that's not the point here. I was assured that SQL Server 2005, as in the previous version, had a "Create one file per object" option. I went searching the net and found out that the feature was missing. Another search and I read that the missing feature appears when updating SQL Server 2005 client tools to Service Pack 2, but the code I post here was already written

ScriptSplitter Related Software