| Author |
Topic |
|
bobmcclellan
Starting Member
46 Posts |
 Posted - 2010-11-19 : 22:53:20
|
| Can anyone suggest software to use for storing codeon projects. I typically open a spreadsheet for a each newproject. I organize the project in the xls thenwrite the stored procs and store all .sql files in the same directory.I then create hyperlinks to each file from the spreadsheetThis works but is very cumbersome.Any advice is much appreciated.thanks in advance,..bob |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2010-11-19 : 23:50:14
|
| TFS?-Chad |
 |
|
|
bobmcclellan
Starting Member
46 Posts |
Posted - 2010-11-20 : 09:32:26
|
| Thanks for the reply Chad. TFS is not what I am looking for.Unfortunately, I am a single programmer and not part of team. I simply want a place to store and organize my code so that I caneasily find and work with the stored procedures associated with each project. When I get calls about a project, I'd like to just open it and have all the related files. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2010-11-20 : 09:48:55
|
SSMS has the concept of "projects" where you can group any number of files together.If you are looking for a free source control system, I can recommend bitbucket.org which uses mercurial as a client.
elsasoft.org |
|
|
|
bobmcclellan
Starting Member
46 Posts |
Posted - 2010-11-20 : 11:08:39
|
| Thanks for your reply jezeminie. I spent a few months using the "projects" & "solutions".They work fine. I just got frustrated with the time it took opening and closing the solutions.I took a look at bitbucket and github.I will need to spend some real time exploring them further.Thanks again for the reply. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-11-21 : 04:38:35
|
| I think you should go for VS2010 Team System since your prime concern is not source control but code organisation which you can do it so easily in GDR project of VS2010.You just need to set up the DB connection for the project & the GDR automatically maintains seperate script files for each object in the DB because of which code refactoring also has become so easy.PBUH |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-11-22 : 11:36:00
|
| I'm not sure what exactly you are doing working with Excel to maintain code.. But, I'd second the suggestions above to use Visual Studio (and TFS for version control). VS is decent and will get you used to something more professional. But, if it will cost you money, I'd wait will SQL 11 comes out. Then we will get something that resembles a real development environment for SQL. |
|
|
|
bobmcclellan
Starting Member
46 Posts |
Posted - 2010-11-22 : 20:05:49
|
| Thanks for the replies Sachin and Lamprey. I appreciate it.I do not have VS2010 But will look into what it offers. At first glancethe Team system looks like it requires the team foundation server to be installed. Sounds like I need to read up on SQL 11 too.Thanks again for the feedback. |
|
|
|
sherr
Starting Member
1 Post |
Posted - 2010-11-25 : 13:03:49
|
| Have you tried SQL Source Control from Red Gate, http://www.red-gate.com/products/sql_source_control? It's completely integrated into SSMS and connects your database to existing source control systems. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
bobmcclellan
Starting Member
46 Posts |
Posted - 2010-11-29 : 08:15:48
|
| Thanks Sherr and robvolk. I appreciate the replies and advice. After viewing the options you've suggested... in addition to the others...I've come to realize that what I was looking for was outside the norm. I wound up building my own app to do what I was looking for. I still havea few things to add but for the most part it is working out well. thanks again,..bob |
|
|
|
|
Organizing Code