SQL and Source Safe

  • I everybody,

    I need a tool to integrate SQL Server Objects and Visual Source Safe. Anybody can help me?

  • The best way is to create scripts for each object and simply store the scripts in VSS. I personally use a database project in Visual Studio to hold the scripts and I also have a connection to the database(s) in my DB project. I can easily check the scripts in and out from my project and as I modify them test them against the database. It may not be the best solution but I always have Visual Studio on my machines and I prefer it for doing my dev work against the database.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

  • There are a few products on the market for this now.

    A couple of the better offerings are available here,

    http://www.xpressapps.com

    http://www.skilledsoftware.com

    --------------------
    Colt 45 - the original point and click interface

  • Can I use a database project in Visual Studio 6.0?

  • You should be able to create a DB project in VS 6.0. Look under "Other Projects" when you create a new project.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

  • I used a low tech approach.

    http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp

  • Very nice article Steve. It's also very similar to the way I work. All of my objects are scripted out. I have a DB Project in VS .Net that I use to hold the scripts. It is then checked in to my source management software. I actually have a very similar file structure as well!

    I've been doing this for the last 8 years with both Oracle and SQL Server and have not had to worry about using an integrated source management system as everything is done through scripts and the scripts are checked in regularly.

    When I'm developing stored procedures I'll typically work in Visual Studio directly against the database. Once I have debugged the SP I'll copy it to a script and check it in. Since I use a lot of macros during the development this is the best solution for me. I've been using Visual Studio in this fashion since at least '97. The nice thing about this is that in all the jobs I've worked at I have always had a version of Visual Studio on my Machine so I never have to buy something else.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

  • I have a VB Script that scripts out all the objects in a db, checks them against the sourceSafe version, and checks the new script if it finds a difference. 

    It is handy for keeping a history, and as I run it every night via a scheduled Task I can stop worrying about losing object changes, as long as an object doesn't change more than once a day.

    It occaisionally generates extra white space in the DMO scripted version, so a new version ends up in sourcesafe thast doesn't need to be there, but this only happens occaisionally.

    I based the script on one I found here, but I'll post my version if you like.

    Dave J


    http://glossopian.co.uk/
    "I don't know what I don't know."

  • Dave,

    I am also looking for that type of job,

    Would you please post the scripts and explain little more?.

    Thanks.

     

  • I'll clean it up (remover server, user names etc.) & post tonight. Promise


    http://glossopian.co.uk/
    "I don't know what I don't know."

  • A little late, but I have just updated the comments at the top & took out passwords etc.

    I'll post this into the script section in a mo' (my first ) but you can also find it at

    http://glossopian.co.uk/pmwiki.php?pagename=Main.CheckIn2VSS

    Note: Make sure you have the appropiate folder permissions where you store this script, as it contains passwords

    posted to the script library as Check DB into VSS


    http://glossopian.co.uk/
    "I don't know what I don't know."

  • sounds good but the download link

    http://www.sqlservercentral.com/products/bwunder/archiveutility/Setup.msi

    is broken.


    http://glossopian.co.uk/
    "I don't know what I don't know."

  • Dave,

    It is a cool script, how can i generate script for jobs ,dts pacakges, uers, and also when we generate script for an object how can i include the permissions.

     

    Thanks,

     

  • You can Query Jobs via DMO, and Users, so we could extend the script to include them.  AFAIK, you can't get DTS pacakges.  They have their own Object Model, but I have a DTS Package that exports DTS Packages

    I have another for Jobs too...

    see http://glossopian.co.uk/pmwiki.php?pagename=Main.SQLScripts


    http://glossopian.co.uk/
    "I don't know what I don't know."

Viewing 15 posts - 1 through 14 (of 14 total)

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