What are the challenges you face when working across database platforms? Take the survey
Options

Different object owners-when will this feature be available?

CodingAngelCodingAngel Posts: 6
edited August 29, 2005 5:08AM in SQL Compare Previous Versions
Hi there.

We are just buying your software because we really found it
very useful and highly functional.
Now we unfortunately found out about the problem that objects
with different owners cannot be compared, or to say it simply:
There is no way to manually specify the objects to be compared.

Now I read in this forum that this feature could be included in a
new major version.

Now my two questions:
- Will this feature be included in the next major version?`

- Assuming this will be case, when is this going to be?

Thanx a lot,
greetings from Germany,

Markus Engelhardt

Comments

  • Options
    Hi Markus

    Because the owner is part of the object name. It is there fore difficult to compare two tables, for example, that have the same name but different owners as the object names don't match.

    However we are adding this in as a new feature in the next version that should be available later this year.

    Regards
    Dan
    Daniel Handley
    Red Gate Software Ltd
  • Options
    Well, I do not want to be a 'wiseass' or something like that,
    but would it not just be enogh to enable a manual selection
    of objects which should be compared?

    Of course, those would be different objects then,
    but nevertheless, structure or even data content could be compared
    then...

    I would find it most useless, if I could just edit the whole comparison
    setting manually and then the whole database could be compared...

    And a maybe even more complex add-on that could be useful, would be
    something like a filter "ignore owner" which would cause the system to look for maches at the table names by itself, so the user could compare
    databses with different owners without having to click every combination
    manually...

    I'd like to repeat, that I do not want to be a wiseass,
    I rather want to make suggestions, which I think could be useful...
  • Options
    Hi Markus

    The problem lies generally within SQL Server and the way it treats objects and names. We have to work within these limitations.

    However as i mentioned we are adding this as a feature to the next release so you can compare objects with different owners. I am not sure how far this will go but i also think you may be able to compare objects with different names as well.

    Please keep and eye out for information about the next release here on the forums and the main web site.

    Regards
    Dan
    Daniel Handley
    Red Gate Software Ltd
This discussion has been closed.