Comments
2 comments
-
Thanks!
We have already thought of this, though. If you synchronize with the force column order to be identical option, then SQL Compare will script a table rebuild and add the new column in the same ordinal place as the original. Be aware there is a potential for data loss! -
Ok, I WILL read the manual the next time before posting
Add comment
Please sign in to leave a comment.
I found a little problem. I inserted a new PK-column in a table and moved that column forward to the other PK cols. That forced a code change in our program. We deployed the new program version and used the diff-script generated with your tool. But our programm crashed on that particular spot where the code change was done. We found out that the diff-script inserted the new col but did not move it to the front cols, but appended it to the last col, so our code couldn't work. Is this a bug or a feature?
BTW we have a idea: What would be great is a filter which only shows the spots that are different in the objects, plus 3-4 lines before and after. Imagine looking for the diffs in a lengthy SP, ok you have the marks, but simply showing only the diffs with one mouseclick would be great!
Besides that: GREAT tool, keep on going!
bye, sascha