Thank you for your reply.

These are good questions!

I did check the truncation and it is happening.

The MYSQL is 5.0 and SQL Server is 2005 version.

There is no identity column.

The...