Currently we are in process of converting production db tables from INT to BIGINT with Sybase ALTER command.
One of the table has 1.5Billion rows which we are unable to convert in one weekend time frame (ran for almost 43 hours then we killed it & restored the DB dumps).
Any other suggestion to convert this table quickly to BIGINT. This table has clustered, unique and non-clustered indexes on it.
I am thinking below solutions: Can you suggest the best way to do this?