Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Source Control for Mixed RDMS/Dev Environment


Source Control for Mixed RDMS/Dev Environment

Author
Message
N.B.
N.B.
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 127
Greetings,

After doing a search for the topic of "Source Control", I found quite a few answers that focused mostly on people who are developing exclusively for SQL Server and mostly using Visual Studio and Visual Source Safe to do the job.

However, my situation is a bit different: We have both an SQL Server environment, as well as an Oracle 11g environment, and have to build and maintain scripts for both.

Typically the development environment for each DB is left up to the individual user, due to how access is set up (our Oracle 11g environment is strictly read-only; the SQL Server environment is read-only for everyone but the three DBA users) - for example, I typically use Sublime Text 2 to do my coding, and then either use SSMS (SQL Server; obviously) or Toad Data Point or SQLTools (for Oracle) to actually execute and debug my code.

As a result, we've got a very large number of scripts that are pre-built and address most - but not all - of the reporting requests that my group gets. Many of them have been converted from Oracle to SQL Server and built into SSRS reports, and users can run them as needed on their own.

Others, due to either the complexity or in-frequency of requests or any number of reasons, just exist in a shared network location. Unfortunately this tends to lead to a lot of duplication of effort - or worse, a junior developer who fails to look closely enough, attempts to re-invent the wheel, and fails miserably, causing others even more work.

What we're looking for is some kind of source control system, preferably one that integrates at least somewhat easily with a Windows Network environment (Active Directory or at least the ability to control access based on NT ID), that has search capabilities, allows to assign permissions to edit or just read-only, etc. It needs to be platform independent when it comes to syntax, but if it uses a database backend, it would have to support SQL Server 2008 or 2008 R2.

Has anyone used a source control system in this type of situation? What did you use and did it work well?
N.B.
N.B.
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 127
Side note: Yes, I realized I screwed up the subject - but it won't let me edit it, so I'm a bit SOL...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search