Comments
Sort by recent activity
another advantage or RG Sql Source Control is that you dont have the added hassle of sorting out cross database references that you find with Visual Studio database projects. so, i'm putting the full list below for my own notes
no annoying conflicts on the .dbproj file
no re-keying from SSMS to Visual Studio (don't have to keep jumping around between IDEs)
much nicer interface
schema comparison less buggy
you can see other people's changes more easily
cross-db references can be annoying in VS database projects
/ comments
another advantage or RG Sql Source Control is that you dont have the added hassle of sorting out cross database references that you find with Visual Studio database projects.so, i'm putting the ful...
just been playing around with this. two more possible advantages of RedGate 1. Visual Studio db projects can have duplicate object definitions 2. I think you can't (easily) see the SQL definitions in dacpacs but you can in SCA nu-get packages (unconfirmed!) / comments
just been playing around with this. two more possible advantages of RedGate1. Visual Studio db projects can have duplicate object definitions2. I think you can't (easily) see the SQL definitions...
"So you're happy with seeing the changes in the branch appearing as items in the 'get latest' screen?" I think so yep. "This should work as expect today except that you'll need to type the git checkout commands manually (it would be great if you could try to switch branches and let us know if the end result in the Get Latest screen is as you would expect)." Typing the git commands manually is what I was I hoping the RedGate UI could do for me! I like having as few applications open as poss, others in my team dont want to use the command line at all. What is the specific reason you wouldn't want it to auto-sync your DB with the state of the new branch? We use shared databases environments at the moment. We have laptops with 250gb hard disks but our DWH databases are much bigger and we haven't looked at making smaller copies because its a bit of a spaghetti architecture. Also, if there is a lot of context switching then you may have a branch you haven't touched for a week or so and its nice to have the control to put things back manually and refresh your memory of what you were doing. cheers, Ben [image] / comments
"So you're happy with seeing the changes in the branch appearing as items in the 'get latest' screen?" I think so yep."This should work as expect today except that you'll need to type the git chec...
Thanks david. I would probably like to be able to create and switch branches from redgate sql source control gui within SSMS, so I can stay in one place. I don't think i would need/want the database to change after each switch of branch though, I could get the database & branch in the position I want using the 'Commit' & 'Get Latest' tabs within RedGate Sql Source Control. What I would ideally be after is this screen which pops up when you click the arrow next to your current branch. [image] Have it appear when you click the branch label in Redgate Sql Source Control [image] Hope that makes sense. I've only been using git for ~7 months so i'm no expert ! / comments
Thanks david. I would probably like to be able to create and switch branches from redgate sql source control gui within SSMS, so I can stay in one place. I don't think i would need/want the datab...
p.s. i actually think there are quite a few advantages of using redgate sql source control vs visual studio/database projects such as
no annoying conflicts on the .dbproj file
no re-keying from SSMS to Visual Studio (don't have to keep jumping around between IDEs)
much nicer interface
schema comparison less buggy
you can see other people's changes more easily
visual studio has improved massively in the last 2 years tho. The pros/cons of each is what i'm currently researching (including the pros/cons between the redgate and microsoft build/release plug-ins in Azure DevOps). But one small advantage of Visual Studio is that it has the branch management gui. cheers Ben / comments
p.s. i actually think there are quite a few advantages of using redgate sql source control vs visual studio/database projectssuch as
no annoying conflicts on the .dbproj file
no re-keying from SS...
Hi @Diogo, @David Atkinson, @Kendra_Little I haven't been using Redgate SQL Source Control for the last couple of years (we've been using Visual Studio and Database projects) but I am now looking at Redgate SQL Source Control again as I prefer the 'connected' method of development. I kind of agree with the following statement made by the original poster. "Ideally, branching would be built into the UI so I could, at a minimum, switch branches". Is this something that you guys are considering? I saw a video where Kendra uses sublime merge for handling conflicts, I was wondering what the redgate teams use for creating/switching branches (excluding the command line)? cheers Ben / comments
Hi @Diogo, @David Atkinson, @Kendra_Little I haven't been using Redgate SQL Source Control for the last couple of years (we've been using Visual Studio and Database projects) but I am now looking a...
I showed this tool to a DBA and they asked if they could import their server lists from their existing CMS registered servers (Central Management Server)... would be a good feature! / comments
I showed this tool to a DBA and they asked if they could import their server lists from their existing CMS registered servers (Central Management Server)... would be a good feature!
Hi - this forum is just for red-gate products. for Microsoft SSRS you are probably better off asking the question on somewhere like stack overflow or looking for a tutorial on youtube. that said, as I am here. you create the report in the client tool SSDT https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017 then you will need to install the server component (where you will deploy the report) https://www.microsoft.com/en-us/download/details.aspx?id=55252 you configure your project properties and deploy from within the client tool SSDT. cheers Ben / comments
Hi - this forum is just for red-gate products. for Microsoft SSRS you are probably better off asking the question on somewhere like stack overflow or looking for a tutorial on youtube.that said, a...
cheers Mike - I believe this has worked!! I don't work too much with triggers, do you know why I wasn't able to find the objects through SSMS / SQL Search? / comments
cheers Mike - I believe this has worked!! I don't work too much with triggers, do you know why I wasn't able to find the objects through SSMS / SQL Search?
ah ok - I just realised it was at Server Level. Server>>Server Objects>>Triggers. Cheers! / comments
ah ok - I just realised it was at Server Level. Server>>Server Objects>>Triggers. Cheers!