• zafar (11/22/2007)


    i wants maintain different versions of my database ie (SP, tables etc)

    How can i do that ?

    You could script your database and keep the script files in source control. This can be automated with SMO, but it may become tedious when it comes to seeing the differences between your different versions.

    You could also look at third party tools like:

    Microsoft Visual Studio Team System for Database Professionals,

    Red Gate's SQL Compare Professional

    DBGhost

    These allow you to use source control with your database objects.

    Disclaimer: I work for Red Gate.

    Regards,

    Andras


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software