Sort indexes alphabetically
mikegood
Posts: 3
I think this is the same problem as mentioned a long time ago in "Feature Request - Sort Indexes Alphabeticaly (Script Export)" posting. Which was fixed a few versions ago?
I'm using SQL Compare v7.1.0.197.
Tables are showing up as different, but only difference turns out to be SQLCompare listing the indexes in a different order. My current workaround is to cut and past indexes from both sides into two different text documents, sort those text docs, then compare them with another tool.
Keys appear to be listed first. After this, though, I cannot understand the order that SQLCompare is listing indexes. Not alphabetical on either side of the screen. I checked indid, it's not that either.
I'm using SQL Compare v7.1.0.197.
Tables are showing up as different, but only difference turns out to be SQLCompare listing the indexes in a different order. My current workaround is to cut and past indexes from both sides into two different text documents, sort those text docs, then compare them with another tool.
Keys appear to be listed first. After this, though, I cannot understand the order that SQLCompare is listing indexes. Not alphabetical on either side of the screen. I checked indid, it's not that either.
Comments
We ought to be sorting live databases properly now, but some of the other database types still have problems that we're working on.
Redgate Software