Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

The Control Poll Expand / Collapse
Author
Message
Posted Thursday, May 16, 2013 10:12 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:10 PM
Points: 33,095, Visits: 15,202
Comments posted to this topic are about the item The Control Poll






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1453837
Posted Friday, May 17, 2013 3:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 6:17 AM
Points: 18, Visits: 144
I am using Mercurial for my small (single-dev) projects.

I like it because it is distributed, simple and scalable. And most important: You don't need a server if using it one a single machine. The repository is stored in a sub-directory of your project.

Side-effect: The file-backup of your project-folder will also back up the whole version history.

With Mercurial there is no excuse left for living without VC!
Post #1453909
Posted Friday, May 17, 2013 4:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 4, 2014 1:25 PM
Points: 165, Visits: 292
I've been using Subversion for about 6 years for SSIS packages. Firstly on a Linux server, and now on a Windows server using CollabNet Subversion Edge (it's free, and provides a nice web interface for remote administration).

A couple of years ago, I convinced my boss to buy Red-Gate SQL Source Control which is linked into the Subversion repository. It's probably now my most-often used piece of software - I check in absolutely every change now, and means I am able to synchronise databases as well as packages. I use TortoiseSVN for SSIS packages.

It's all a bit of overkill at the moment, as I'm the only developer using this VC solution at the moment. However, it means that it's really easy to get a new developer set up with the stuff that they need to do any development work. I don't have to grant them access to the live server - just source control.

For all of the effort that it takes to set up (about half a day including building the VM that hosts it) it's saved me so much time in deploying code to live, making sure that I've always got the most up to date version.

The only shortcomings I've seen so far in the software I've selected is that you can't store snapshots of jobs in version control (unless you script them into a procedure), and you have to drop out to Windows Explorer to commit the local version of SSIS packages. There are Visual Studio shell extensions available, but I've not found one that does everything that I want for a sensible cost.

Cheers

Ben
Post #1453928
Posted Friday, May 17, 2013 5:56 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 21, 2014 7:42 AM
Points: 292, Visits: 757
I'm with Ben. I invested the time and money in RedGate's SQL Source Control several years ago, and have never looked back. Having not had much experience with source control prior to that, there was a small learning curve, but I can't imagine developing anything without it now. Our dev team also recently grew in size, and source control allowed us to maintain different dev, testing, and production environments with very little overhead/complexity.
Post #1453951
Posted Friday, May 17, 2013 6:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 5, 2014 12:18 PM
Points: 44, Visits: 467
I use Visual SVN in VS2012 for SSDT, SSIS, and SSRS.

We are looking into RedGate source control
Post #1453955
Posted Friday, May 17, 2013 6:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 5, 2013 6:25 AM
Points: 112, Visits: 402
I use CVS. It is easy to set up, use and free.
Post #1453957
Posted Friday, May 17, 2013 6:41 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 2:20 PM
Points: 486, Visits: 146
I've been using Serena Version Manager for over 8 years now. I can't really imagine life without it. Stored Procedures, Views, SSRS Reports, Entire SSAS solutions, even some documents and jpegs get checked in there. I don't have to worry about anyone over-writing my code when I have anything checked out. If I toast something I'm working on, I always have the option to refresh back to the latest version that was checked in. I can do a diff between files and see what's changed, plus there are notes kept with each version change along with the last check-in date. All work is bridged back to our project documentation, so you can always see why the change was made. I probably wouldn't consider a position elsewhere if they didn't have similar capabilties available. It's just too easy to do, and it adds such a security blanket. It would be foolish not to use a VCS.

In addition to that, we have a shared drive that automatically backs up every hour. It always keeps a couple of days worth of snapshots, and all versions are available through file properties. We can save new development and anything that's checked out there, and you can easily get a version of a file backed up from earlier in the day before you had problems without going to tape. You can get whole folders back if necessary. I don't need to do it that often, but boy is it nice to have when you need it.
Post #1453965
Posted Friday, May 17, 2013 6:43 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:23 AM
Points: 1,627, Visits: 1,070
We are still non-distributed, and use SourceGear Vault, happy enough. Anyone got compelling reasons to go distributed?

The only time I have not checked any code in recently is when a released version needs patching, an updated version is in progress, and we have not properly forked at release for whatever reason. This would rarely tend to happen to be fair.
Post #1453967
Posted Friday, May 17, 2013 6:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, December 2, 2013 6:30 AM
Points: 346, Visits: 691
I'm a single developer/DBA/chief cook & Bottle washer at my company. I use Subversion tied into Visual Studio and SSMS/Windows Explorer.

I actually like using Explorer as my navigation shell, Win 7 makes grouping and searching different types of stored procedures quite simple, with editing etc. in SSMS.

There's nothing quite like knowing I can roll back a change or get back an accidentally deleted SP or VS file. I would recommend version control for any project that changes frequently. The only things I don't put in version control are the ERD and a few Access tools that do the grunt work of creating CRUD SPs.

Plus it gives an additional layer of backup, another copy is never amiss when something goes south!
Post #1453970
Posted Friday, May 17, 2013 6:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 5, 2014 12:18 PM
Points: 44, Visits: 467
For users of the RedGate solution do you recommend Shared Database Development or Dedicated?

I am leaning towards Dedicated, my coworker is leaning towards Shared.
Post #1453972
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse