SourceSafe Alternatives

  • Currently our programming teams use Visual SoureSafe for source control. We have to export our SP's (and views) to a text file and then import them into SoureSafe.

    Can you recommend any alternate products that have true support for SP's and Views?

    TIA,

    Bill

  • Hi Bill,

     

    You should take a look at

    Imceda's SQL IDE, it is pretty much becoming the defacto SQL Server IDE product and it has excellent integration into VSS. We also produce the fastest and most feature rich database compare utility.

    http://www.imceda.com/SQL_IDE_Description.htm

    Regards

    Douglas Chrystall

    Imceda Software, Inc

    SQL IDE

  • Thanks Douglas, I'll "take a look".

     

    Bill

  • hello Bill,

    you might also want to take a look at http://www.dbghost.com which ties into Visual Source Safe and daily build processes giving you true database change management.

  • If you use the Visual Studio IDE to edit your SQL you get full SourceSafe integration, and can also use the debugger

    hope this helps

  • Is that Visual Studio.NET or Visual Studio 6?


    When in doubt - test, test, test!

    Wayne

  • either

  • I have found that getting programmers to work with SQL sproc scripts on disk gives a very high level of control. This means you can use a script to extract changes from Source Safe and then apply them in bulk to the test or production environment.

    We use these scripts for all database changes including table structure changes and bulk updates.

    All I need is a WSH script I have written which runs recursively over directories in sorted order invoking OSQL on all scripts and logging any problems.

  • I believe the SQL Server SP integration into Visual Studio IDE requires the Enterprise Edition of Visual Studio.  In Professional version you can see the database objects but don't have the modification capabilities (nor the T-SQL Debugger!)that exist in the Enterprise Edition.

    Just tryuing to clarify the issue further.

     

  • Hi sqluser

    could u tell me which tool to use in visual studio to edit sql plz?

    under my visual studion 6.0 menu there r many tools vb,foxpro and interdev etc.,

    i am wondering which one to use!

    many thanks

  • Personnally I find Query Analyzer to be all I need. I can associate SQL file extensions with it and use VSS - just right click the item in the VSS interface, select edit and I'm now editing the file and have it checked out. Visual Studio just doesn't cut it for me. QA has everything I want - I know there are tools out there and I've tried them but QA is still the best for me, in fact if they gave the other tools away I would still use QA. Best of all it's free.

    regards,

    Mark Baekdal

    http://www.dbghost.com

    Living and breathing database change management for SQL Server

     
     
  • http://support.microsoft.com/default.aspx?scid=kb;en-us;818368 for vs.net, and

    http://support.microsoft.com/default.aspx?scid=kb;en-us;201240 for vs6 (looks like it's best to use interdev)

    I tried and used this for a while, and it does work.  The only downside I would say is that you don't version table designs etc, but they can be backed up.  Remember if you use UDF's a lot, these don't seem to integrate well with vs6 (as they came along after vs6).  In all honesty, I haven't tried UDF inetgration in vs.net (any version).

    If you're interested in VSS, there is a book http://www.hentzenwerke.com/catalog/essvss.htm I would reccommend - it is all the *other* stuff about VSS, the stuff you don't read every day on msdn

    hth

  • hi sqluser

    Thank you very much for the links.

    I get the idea

Viewing 13 posts - 1 through 12 (of 12 total)

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