September 20, 2007 at 12:05 pm
Hi All,
This weekend i backup and restored production database in my UAT server. After the refresh i did some column value changes in one table also i did the same procedure in my Development server. Today i noticed that the table doesn't have any index in the UAT server. But in dev and produciton the index are there. I have no idea how the index was dropped. Is it possible if we change column will drop indexes? Also i need to compare the produciton indexs for all the tables with my dev server index. HOw to do the comparison? please help me on it. We are using SQL 2005.
Regards
Moosa
September 20, 2007 at 12:38 pm
There are several companies including Red gate and ApexSQL that offer tools to compare database strcutures (including indexes def). But as far as why did you loose the index what did you actually do?
September 21, 2007 at 11:31 am
I actually use the product, SQL Compare, from Red Gate to do just this kind of thing. It works very well. Best of luck.
September 21, 2007 at 11:32 am
You did some "Column Value Changes".
Did the statement start with an "ALTER" or an "UPDATE" Or did you just use the GUI?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply