Post reply

Source Control System

  • February 17, 2011 at 9:45 am

    #246891

    Any one use source control system for queries and stored procedures?

    If so what is the source control system you use?

    And can they be also used for reporting service reports, or SSIS packages?

    Thanks

  • February 17, 2011 at 10:04 am

    #1288358

    I use SubVersion. For all my SQL Code and SSSIS packages for DWH.

    ANd these plugins :

    Redgate SQL Source Control(For Table,Stored procedure)

    Tortoise(For documentation)

    Tortoise&AnkhSbvn(For SSIS,*.sln) Solution

  • February 17, 2011 at 10:43 am

    #1288391

    By linking database to Source control system, will that affect performance of sql server?

    Never used source control sytem before, should the tool only be used on development server but not production server?

    Thanks

  • February 17, 2011 at 10:44 am

    #1288393

    I've put just about everything except the server configuration itself into source control. Yes, you can do this will all projecs and objects. Visual Studio works really well with Team Foundation Server (TFS). I've also used SVN with Red Gate SQL Source Control to check in database ojects. Also did that with TFS. There's a whole section of the Team Development[/url] book on using Source Control.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 23, 2011 at 3:28 am

    #1290287

    Hey friend

    I happen to know a really nice tool which solves SQL versioning problems and more. you should check it out.

    Cheers, Daniel

Viewing 5 posts - 1 through 4 (of 4 total)

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