Comments
Sort by recent activity
I'm not sure what you mean here. If you are using git, then you connect to your git repository. The TFS part doesn't matter. If you are trying to connect to the TFS git repository on the server, you're incorrectly setting this up. I use TFS online and the git interface with SQL Source Control. You should have a cloned repository on your local system that you setup as a git cloned repo from TFS. When linking to the database, choose Git, not TFS. / comments
I'm not sure what you mean here. If you are using git, then you connect to your git repository. The TFS part doesn't matter. If you are trying to connect to the TFS git repository on the server, yo...
Also, which SQL Source Control version? / comments
Also, which SQL Source Control version?
I wasn't sure what you were doing. Is there a reason you can't set a git repository on your machine that points to a remote in TFS? I haven't tried the git in TFS. I've used TFS or I've used git that points to the repo in TFS. / comments
I wasn't sure what you were doing. Is there a reason you can't set a git repository on your machine that points to a remote in TFS? I haven't tried the git in TFS. I've used TFS or I've used git th...
If you are using the git interface, that should be the URL you include. For example, I have the local path for my git repo.
For TFS, you should have entered the entire TFS url to your repo. This can include the /tfs item in your setup. Check that tab when your database is selected. / comments
If you are using the git interface, that should be the URL you include. For example, I have the local path for my git repo.
For TFS, you should have entered the entire TFS url to your repo. This ca...
We don't have a programmatic interface for SQL Source Control. This was
built for interactive work with developers and there is no API. / comments
We don't have a programmatic interface for SQL Source Control. This was
built for interactive work with developers and there is no API.
First, you could potentially have a way of auto committing, but you'd just be capturing changes without any context. No comments. That's not necessarily a good way of performing development. In the past, I've used auto scripting to do this. I don't know that SQL Compare could be automated to do this, but I wouldn't recommend it. Instead, I'd say that you should really be using something like SQL Compare to look at the db v VCS and alert you that changes need to be committed.
In terms of dealing with a volume of changes. The person that makes the change should commit it when they think it's done. Auto committing is bad because the work might not be done. You want there to be some decision to do this. If you can't keep up, then perhaps you have other development chaos. / comments
First, you could potentially have a way of auto committing, but you'd just be capturing changes without any context. No comments. That's not necessarily a good way of performing development. In the...
Done: https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/31791202-keep-static-data-stored-in-pk-order
I like this idea. It's really more a Data Compare item, but I'll let them know. / comments
Done: https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/31791202-keep-static-data-stored-in-pk-order
I like this idea. It's really more a Data Compare item, but I'll let the...
I don't know there will be any fix here. We've end of life'd DLM Dashboard for a variety of reasons. We are working on a replacement for this that includes some functionality. Some notes in here: https://www.red-gate.com/blog/database-development/why-and-how-you-should-automate-database-migrations / comments
I don't know there will be any fix here. We've end of life'd DLM Dashboard for a variety of reasons. We are working on a replacement for this that includes some functionality. Some notes in here: h...
Are you on version 1.7.5.x? / comments
Are you on version 1.7.5.x?
I'll apologize, though I know this isn't what you want to hear. The data is in a RavenDB system in ProgramData\Redgate\SQL Lighthouse. I downloaded Raven yesterday, but haven't set it up. I need to do this and get some client queries. Maybe I can help figure out what might be wrong. If I can, I'll post something. My suspicion is something got into an error state and the data is incorrect somewhere. Likely the error handling isn't sufficient to deal with this. I haven't run into this. I've added DLM Dashboard to a dozen or so installations and haven't had this issue. I have been able to run the setup script on a new server, then add the server in the dashboard without issue, and I might suggest that if you are open to digging around. What I'd suggest is removing the server from the config, and restart the DLMDashboard services. Then setup a new login on your instance that has the permissions. Sysadmin if you don't mind, otherwise, the permissions are doc'd here: https://documentation.red-gate.com/ddb1/getting-started/creating-a-login-with-the-correct-permissions I usually use a separate login, just for security purposes and so I can trace things. I've setup "dlmdashboard" as my login, with limited permissions. I then run the setup script (https://documentation.red-gate.com/ddb1/files/38043983/41358394/1/1459336529080/create_ddl_trigger.sql) to create the Redgate database. From here, if I add the new instance in DLM Dashboard, it seems to work smoothly, and when I pick a database, small or large, it grabs the schema and lets met set a version immediately. Again, I apologize. I know these are cheap words, but I'll see if I can find out more info, or get some debugging hints from a developer or two. / comments
I'll apologize, though I know this isn't what you want to hear.The data is in a RavenDB system in ProgramData\Redgate\SQL Lighthouse. I downloaded Raven yesterday, but haven't set it up. I need to ...