Activity overview
Latest activity by kevinwoodward
SQL Compare not comparing properly.
I am running a compare, in that compare I have a table that has dropped or renamed 3 columns. This should be compared as a drop and an add in the compare and in script generation, but it seems that...
Hi Michelle,
thanks for the quick response,
I could not consitently paste the table name in my include filter for tables.
I couldn't pin down the exact sequence of when paste would work.
I was copying from a SSMS window, changing the operator to equals and pasting the table name into value.
when not working, right clicking would show that paste was grayed out.
it was very strange.
I had better luck CUTTING the table name and pasting it, but I don't know if that was related at all since it was so inconsistent.
I am using the tool on Windows 2008, I was also connecting to that box through remote desktop. Which I am sure complicates reproducing the issue.
as far as getting the names into my filter, I ended up editing the filter xml file, that worked fairly well after a few attempts.
As far as the table order, the force column order was not checked.
The columns moved but there was also a new FK on all of them, which is why the difference was coming up. So ignroing FK's fixed that for me.
Again,
Thanks... / comments
Hi Michelle,
thanks for the quick response,
I could not consitently paste the table name in my include filter for tables.
I couldn't pin down the exact sequence of when paste would work.
I was copy...
Quetions and Problems with SQL Compare 8
Hello All,
I inherited this tool kit at my new position.
I am trying to use SQL Compare 8 to identify changes in certain tables...
many questions and issues have come up
I have a list of 70 tables,...