Skip to content

Settings and activity

93 results found

  1. 18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

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

  2. 4 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  ·  Oracle » All Oracle  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    There's no way of doing this right now, although it's something we might add in future. Your best bet is either to add it manually, or if you're automating, run your own pre-deployment script with sqlcl or sqlplus prior to running Schema Compare's deployment script. Can I ask why you need this particular statement? Are you generating scripts without schema names so you can execute on a different schema target?

  3. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    Thanks for the feedback. Yes, this is a limitation of the product today. We currently suggest users just recreate the project, but we acknowledge that this is a workaround and not very practical. We have an item on our backlog to allow all aspects of a project to be modified after creation.

  4. 6 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    Interesting idea. You could of course build something rudimentary using tSQLt, but I'm wondering whether this could be implemented in Redgate tools as a configurable "high" deployment warning (high so it will can halt/pause an automated release process).

  5. 5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    This should be straightforward using the existing command line tool of your VCS (sg svn.exe or git.exe) alongside the DLM Automation commandlets.

  6. 11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @Hans - I think this *is* possible today. In the Edit Project screen can you visit the Tables and Views tabs, and using the buttons at the bottom of the screen, unmap the two tables that you want to compare, and remap the two that you want to compare.

  7. 16 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @sarmadh - what would your preferred way be of making this specific change?

  8. 6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    One option is the /report command line switch. Scroll to the bottom of: https://www.red-gate.com/simple-talk/sql/sql-tools/mysql-compare-the-manual-that-time-forgot-part-1/

  9. 5 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @rich - have you considered using the command line, sqlcompare.exe to achieve this? I'm pretty sure that this can take in a project file as an argument, and you can specify the source and targets as separate switches.

  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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    Which VCS are you using? If it has a command line you should be able to achieve this by using it in conjunction with the Schema Compare for Oracle command line.

  11. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @Lee - Thanks for the feedback. Out of interest, what is the reason you save off this script?

  12. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    @Josh - This could be a bug. I've sent you an email.

  13. 14 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 
  14. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    Have you tried the command line? This would be a way of running multiple comparisons simultaneously.

  15. 14 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 Search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    Can you tell us a little about the use case? ie, what problem would this help you solve?

  16. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    Are you referring to SQL Compare or SQL Source Control?

  17. 12 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 Search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    It's possible to copy the contents of the results grid and paste into Excel.

  18. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    I was going to blog about how to do this and I've been putting it off. I will email you individually and show you how this can be done.

  19. 8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    Are you referring to comparisons using SQL Compare rather than SQL Source Control? I'd be curious to know if you've tried using the DLM Dashboard and whether this helps solve the problem you have? http://www.red-gate.com/products/dlm/dlm-dashboard/

  20. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDavid Atkinson (Product Manager, Redgate) commented  · 

    How does this differ from the view you get from the commit tab in SQL Source Control? This is essentially a list of modified (or new) objects with a difference viewer below showing the exact change.