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

SQL Compare and Out of Sync Tables

Hi,

I've been testing the scenario (which we've had many times with our manual upgrade procedure) where a table is out of sync between two databases, specifically w.r.t the column orders. For example, say Table X has columns A, B and C. In Database 1 Table X is setup correctly as Columns A, B and C. However, in database 2, Table X is setup as Columns A, C and B. SQL Compare doesn't seem to pick the difference up; except if I'm doing something wrong. Note, in this example, Database 1 is my source control database and Database 2 will be my deployed database.

Please let me know if I'm not explaining myself well or if you need any further information.

Thank you in advance!

Johan
Marius
0

Comments

3 comments

Sort by
  • Rob C
    Hi Johan,

    In the project options, there is an option called "Force column" order. If you turn this on then it will force SQL Compare to report a different column order as a difference. This option is turned off by default.

    Does this answer your question?
    Rob C
    0
  • jmostert
    Hi Robert,

    Thank you for the feedback.

    That sounds perfect. However, would you mind directing me to the Project Options? I'm a complete novice when it comes to the software as I'm currently evaluating it. What I've seen thus far is excellent. I would like to test this scenario though as it's given us many headaches in the past.

    Kind regards,

    Johan
    jmostert
    0
  • jmostert
    Hi Robert,

    Please ignore my last post. I found the setting.

    Regards,

    Johan
    jmostert
    0

Add comment

Please sign in to leave a comment.