Toad World® Forums

Question about auto-increment number


#1

Hi

I am wondering if it is possible is it possible to make auto-increment in MySQL5 = Identity and Identity seed = 1 and Identity increment = 1 in MSSQL as default?
Because when you alter script from mysql5 database to a MSSQL database you need to edit each of the autoincrement field individually to make it auto-increment. Or it is a bug that it cannot convert auto-increment number from Mysql to MSSQL?

Please let me know if you want me to explain more.

Many thanks

Chi


#2

Hello,

Thanks very much. We will deal with this issue (still enhancing the Convertor). CR # 36 310.

Thanks again!

Regards,

Vladka