Challenging question on SQL Server

[MavrickStl]

Hi Guys,

Here is the problem I am facing:

I am trying to change size of a column from char 8 - to char 10 in SQL Server 6.5. As far as I know there is no way you can do that in SQL Server 6.5. So to overcome this problem I generated SQL script of existing database with field size 8 and modify it to char 10 then used this modified script to create a brand new database.

I thought I could use data object/transfer tool available in SQL server 6.5 to transfer the data from old database to newly created database. I unchecked all the options except copy data option in data object/transfer window. I am still not able to transfer any data from the old database? I don’t know why it is not transferring the data. I looked at the log but there are no errors related to data transfer.

Can anyone please shed some light on this issue? I would really appreciate it.

Thanks,

Mav

P.S. I can transfer the data if I check all the option including copy schema, Drop destination object first etc. But then I can not change the field size from char 8 to Char 10.