Settings and activity

  1. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    SQL Source Control has an "owner" column in the commit screen (after the "type" column) that shows the schema an object belongs to. Is this what you're looking for?

  2. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Data Compare  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    You should be able to load a .scp into SQL Data Compare and a .sdc into SQL Compare today.

  3. 24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Oracle  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    We're sorry about this issue. We're rewriting the GUI and hopefully we'll ensure that there's an option to multi-select rows and set the checkbox state in the new GUI. In the meantime the workaround is to use Schema Compare for Oracle, comparing the scripts folder with the database. Schema Compare allows rows to be multi-selected and the space bar will toggle the checkbox state.

  4. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Data Compare  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    You can sort on the checkbox column and all the selected tables will group together.

  5. 8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  SQL Change Automation  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @Ian Wilkinson - have you tried the sqlcodeguard.exe command line for this purpose? https://documentation.red-gate.com/scg/sql-code-analysis-documentation/code-analysis-for-sql-server-command-line

  6. 32 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  SQL Compare  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @anonymous - worth considering a migrations-based approach, so you can explicitly decide what changes are made to your database. Alternatively consider using a pre-deployment script that drops / truncates your tables.

  7. 22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  SQL Compare  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @al gruver - SQL Dependency Tracker does just that. It's not an ERD tool in the sense that you can make edits to the diagram and push these changes to a live database, but you can reverse engineer from a database to create a diagram.

  8. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Compare  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @david rizzo - Would you be able to provide more context around why you need this?

  9. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Compare  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @chris woods - Thanks for this idea. We may eventually do something like this in future so we can better provide reports / audit trails on past deployments, but in the meantime I would imagine you could do this yourself from your deployment tool by adding a step post-deployment that updates an extended property?

  10. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Source Control » Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @ben b - when you say "allow git clones", can you be more specific about the problem this would be solving and where in the workflow you feel this should be? Do you mean branch creation once you have a local clone, or creating the clone from a remote URL?

  11. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Compare  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @tdennis - sorry for the late reply. This option already exists. If you select "Backup of target" in the Deployment Wizard, the first radio button is "Create a SQL Compare snapshot".

  12. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  SQL Compare  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @T - What are you using the snapshots for? To understand how best to solve this problem, we would need some context about your scenario.

  13. 473 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    64 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Kendra responded

    Thank you everyone for the suggestions and votes for this over the years.

    I’d like to surface up a workaround for the “linking” problem which is mentioned in the comments. For the use case of easing pains around environment setup with a large number of databases, we have had customers find success using code based off Alessandro Alpi’s blog post: https://alessandroalpi.blog/2016/06/28/automatically-link-databases-to-red-gate-sql-source-control/

    I do understand that this is a broader issue and hear that many of you also want command line or API support for the product in general.

    If there are specific scenarios or workflows that would be useful to automate for you, this feedback is also very useful, and if you have details on the type of VCS you use and the workflow (such as a branching model) that it would fit in to, that would be very helpful for us to hear as well.

    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    It's worth also adding that we do already have command lines that allow this. To see your changes you can use sqlcompare.exe to compare your dev DB with your local scripts folder, and provided you wan to pull all the changes down, you can so this with the /sync switch. Choosing a subset is possible, but tricky, hence my previous question.

    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    This is a great idea, and one that we will have to address as the popularity of VSCode and Azure Data Studio increases. How do you see the commands looking, and how would you expect to interact with them? For example, if there are 10 changes to your dev DB, and you want to commit a subset, how would this work?

    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    The reason I ask is that we do have plans to add an auto-link for the shared case, although would you want it to auto-link for everyone, or just pre-populate the repo URL if a user chooses to link it? It's possible to also have something in the dedicated case so long as the extended property is set in the database, and this depends on how the dev DB has been restored/created.

    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @Justin - Are you on the shared database model or dedicated?

    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @Nettec - you should be able to do this with SQL Compare's command line, sqlcompare.exe. You just pick the database as the source, and a scripts folder as the target. Then you use the svn command line to commit the changes. Please contact support@red-gate.com if you need more help. Command line switches for sqlcompare.exe: http://www.red-gate.com/supportcenter/Content/SQL_Compare/help/10.0/sc_cl_Switches_in_the_cl

    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    We hope to achieve this by storing a database-level extended property with the repository location. This means that linking a database won't require typing in the URL and folder details. I'm not sure this will make the next version, but hopefully not too much longer after.

    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    We acknowledge that the one-off set-up is tedious when multiplied by the number of developers. In the next version we'll be starting to store metadata such as version and repository information in database level extended properties. This will allow us in future to auto-link databases once the extended property is detected. This won't make the very next release, but should follow shortly afterwards.

    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @Kit - ideally we'd like to build any automation feature into the product rather than requiring you to automate yourself. Do you envisage that each developer has a way to browse a source control repository, select a version and build and link a database from that version in a single action?

  14. 99 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    Kendra responded

    As David mentioned in the comments, we currently recommend Flyway to help version changes for Snowflake.

    Flyway doesn’t help with authoring or scripting changes, but it does provide a framework and guidelines to consistently version your changes in a deployable fashion that’s suitable for automation.

    https://flywaydb.org/documentation/database/snowflake

    Thank you for the suggestion and comments, as well those who have voted.

    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    Thanks for the feedback. In the meantime, a good option is to manage Snowflake using Flyway. https://flywaydb.org/documentation/database/snowflake

  15. 16 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Prompt » Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @nihar - Please consider using the code analysis command line in the meantime. https://documentation.red-gate.com/scg/sql-code-analysis-documentation/code-analysis-for-sql-server-command-line

  16. 108 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    28 comments  ·  SQL Prompt » Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @SAinCA_Mi9 If developers are running this from local dev machines then the SCA license doesn't apply, so that could be an option.

    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @Stephen - Alhought the SQL Code Guard SSMS add-in has been retired in favour of SQL Prompt, you can still use the SQL Code Guard command line to run SQL Prompt's code analysis rules. https://documentation.red-gate.com/scg/sql-code-analysis-documentation/code-analysis-for-sql-server-command-line

  17. 19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    Have you considered using the sqlcompare.exe command line along with the git command line to run the script? You can use any scheduler (Windows Scheduler or Agent Jobs).

  18. 55 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    15 comments  ·  MySQL tools » New tool idea  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @Thazul - it's certainly not out of the question and I'd like to see this happen at some stage. We have a MySQL comparison tools already, and the FlySQL project proved the concept.

  19. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  SQL Change Automation  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @Andy - have you considered using the SQL Doc command line instead?

  20. 18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @nicholas - out of interest, which IDE are you using?

← Previous 1 3 4 5