Competition: What’s your favorite Redgate tool? Enter now.

SQL Compare - Source DB Tables - no indexes shown

jackslyfieldjackslyfield Posts: 6
edited May 14, 2007 12:39PM in SQL Compare Previous Versions
Hi,
I am comparing an empty (no data) database to a production version of the database.

Your software responds saying there are indexes / keys on the production version but none on the empty database version. However, a simple SP_HELP on the table shows the indexes do exist. This is true for either database.

I need to get a clean run. What's up?

Thank you,
Jack Slyfield
[email protected]

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Jack,

    Honestly I have no idea. If the SQL Compare settings were set to ignore indexes, it would do it for both sides. What is the output from sp_help on the table and what kind of indexes are these? Are they fulltext indexes, or regular clustered/nonclustered/unique indexes?
  • I have received a second copy of the empty database from the vendor. This copy compares correctly. I've no idea what the issue was with the first copy. I can only conclude it was somehow related to the database being 'zipped' when I recieved it.

    That is not much of an explaination to me. None the less, this issue can be closed.

    Thank you very much for working with me on this issue.

    Jack Slyfield
    Mutual of Enumclaw
    Enumclaw, Washington, USA
    [email protected]
Sign In or Register to comment.