Thanks for your post.
I've just tried making the same change as you mentioned (from Int to Bigint on the PK column of a table, with no other options) and SQL Compare scripts this as an ALTER.
Can you confirm which version you're on? Also, there are several other reasons why a table will get rebuilt rather than altered, which are detailed in this article
- so you may want to check you haven't got the "Force Column Order" option selected, and none of the other possibilities are relevant.
Generally if you want to contact us to look at a specific issue, its best to email email@example.com
- the forums are more intended for users to post non urgent issues where other users can also contribute answers. We do get alerted to un-answered posts so we can respond, but this is obviously a slower way to get help!