Activity overview
Latest activity by jornvango
Thanks Alessandro. We will link the 'msdb' database on the Production SQL server to source control and see if we can commit job changes. / comments
Thanks Alessandro. We will link the 'msdb' database on the Production SQL server to source control and see if we can commit job changes.
Source control on SQL jobs?
We run a variety of nightly SQL jobs using the SQL Server Agent. Can we use RedGate Source Control to track changes on these jobs? Currently, as far as I understand, we need to create a repositor...
We are using SVN (VisualSVN Enterprise server). I have downloaded TortoiseSVN. This free software provides search functionality. / comments
We are using SVN (VisualSVN Enterprise server). I have downloaded TortoiseSVN. This free software provides search functionality.
Search commit history?
Our list of commits is getting quite long and it's getting hard to scroll through the list (in SQL Source Control) to find an older commit. Does SQL Source Control have search - functionality to s...
What's confusing me is that we don't really want to go back to a point in the past. We have 2 databases, both linked to the same SVN repository by using Redgate SQL Source Control. We have unlinked one of the 2 databases but those items are still showing up in the repository. How do we get rid of them? (without affecting the actual database; we just want to clean up the repository as if the 2nd database was never linked) / comments
What's confusing me is that we don't really want to go back to a point in the past. We have 2 databases, both linked to the same SVN repository by using Redgate SQL Source Control.We have unlinked...
Running the script to setup object locking (Redgate Source Control)
Our DBA has been executing the script to allow for Redgate Source Control to lock a database object ('check out'). However, the script has been running for over an hour and seems to be stuck on th...
Undo a commit?
We have downloaded the Redgate Source Control and SQL
Compare Pro trials. We have a SQL Server
environment and Subversion server (shared development model). After installing the Redgate software,...
Sergio, 1. Why don't you recommend git with the shared model? Is there something inherently troublesome with Git regarding the shared model? 2. Can you recommend an alternative to git that will allow us to use the shared model? We don't have to use Bitbucket. We are open to looking at a solution that will allow us to use it in the best possible manner. E.g. TFS? / comments
Sergio,1. Why don't you recommend git with the shared model? Is there something inherently troublesome with Git regarding the shared model?2. Can you recommend an alternative to git that will allo...
Thanks! To follow-up on question 3: you recommend using the dedicated model where each developer works on his own database before pushing tested changes to the (1) live production database? / comments
Thanks! To follow-up on question 3: you recommend using the dedicated model where each developer works on his own database before pushing tested changes to the (1) live production database?
Thanks! Some more questions: 1. I'm setting up a test database in SSMS so there is no remote repo of it yet. Does the same apply: I commit to a (blank) local repo and then will have to use a 3rd party tool once to push to Bitbucket after which Redgate will handle the future commits/pushes from within SSMS? 2. When I select "Git" in Redgate and select a blank folder on my hard drive, it says "That folder isn't in a Git repository". How do I create one since I have no online repo to clone? 3. When I select "Git" in Redgate, it only allows me to select "Dedicated database". However, we all work on a shared/central SQL server so I need to be able to select "Shared database". Does this "database" apply to the actual SQL server database or the local repo? / comments
Thanks! Some more questions:1. I'm setting up a test database in SSMS so there is no remote repo of it yet. Does the same apply: I commit to a (blank) local repo and then will have to use a 3rd p...