How can we help you today? How can we help you today?

Compare wrongly indicates tables do not exist on one server

I compared a database on server A and B and successfully ran the script generated by SQL Compare on B to make it equal to A.

When I now compare again, SQL Compare indicates that three views do not exist on server B. However, they do exist. Running the synchronization script on B gives the obvious error message : There is already an object named xyz.

Version 3.2.0.5 (just updated to this version)

Hans
Hans Van Eylen
0

Comments

6 comments

Sort by
  • Brian Donahue
    Hello Hans,

    This wouldn't possibly have anything to do with running the script on a case-sensitive database, would it?
    Brian Donahue
    0
  • Hans Van Eylen
    Hello Brian,

    no, the databases are not case-sensitive.

    Hans
    Hans Van Eylen
    0
  • Brian Donahue
    Hello Hans,

    What if the objects that already exist in the other database are not views?

    Can you try: 
    select ID, xtype from sysobjects where [name]='xyz'

    The XTYPE column will tell you the type of object (see BOL for more information). For instance, U is a table.
    Brian Donahue
    0
  • Hans Van Eylen
    Hello Brian,

    when I ran the compare I assumed the SQL Compare did indeed find the three objects on server A and not on B.

    When I ran the query on sysobjects however, I found out that they exist on B (as type V) and not on A. Nevertheless, SQL Compare indicates the opposite (blue arrow pointing from A to B) and proposes the wrong script (creating objects on B and deleting them from A).

    I can send you screenshots and scripts if you like. Company policy does not allow me to put them on a public forum.

    thanks

    Hans
    Hans Van Eylen
    0
  • Brian Donahue
    Hi Hans,

    Sure! Can you please send them to support@red-gate.com? XTYPE V is a view, by the way.

    Thanks!
    Brian Donahue
    0
  • Hans Van Eylen
    Apparently this is a frequently occurring issue :

    the name of the view was adapated with Enterprise Manager in the DDL. As a result the name of the view in the DDL is different from the one in sysobjects.
    The top part of the window uses sysobjects, while the scripts come from the DDL.

    I've suggested that future versions of SQL Compare detect such inconsistencies and warn the user and it already seems to be on their to-do list.

    Thanks to Brian for investigating this together with us.

    Hans
    Hans Van Eylen
    0

Add comment

Please sign in to leave a comment.