What are the challenges you face when working across database platforms? Take the survey

SQL Compare 12 - Question

We are upgrading all of our tables to Bigint on all of the primary keys. How can I get SQL Compare to write a temp table to move all the data from the primary table to the temp table. I have ran a test and all it does is drop all the indexes and fks and pk. Then just does an alter on the column being changed to bigInt. Then aborts.
Sign In or Register to comment.