Post reply

Splitting generate scripts by object

  • October 11, 2006 at 8:28 am

    #115126

    I am running 'generate scripts' to maintain the database schema. Is there any easy way that the generated SQL file can be split into several files by object to simplify version control?

  • October 11, 2006 at 1:53 pm

    #665301

    Not in 2005:

    You will have to write your own code using Microsoft.SqlServer.Management.Smo .Net library to do it.

    If you are interested, I have created a rather raw mockup of such application in C# (for my own purposes). Just drop me a quick email on serge@compros.com.au and I will send the source code for that.

    Otherwise you could search on the topic on Google - that was my first step when I had to do the same thing about a week ago - you can find the code samples there.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply