MSSQL and MySQL

I'm copying tables from MySQL Database to MS SQL Database, but whenever I edit the 'Default' row - choose Auto_Increment (with attributes of: No default value, Custom, NULL, & Auto_Increment) a syntax error shows, "SQL Error (102)" and If I tried it back to No default value. Error will keep shows up. Why is that?

The DEFAULT clause handled by HeidiSQL is mostly MySQL syntax I'm afraid. Read here about setting a column default on MSSQL columns.

Hi

What I did was to create a dummy table in MsSql with a autoincrement , integer field,string field ,memo field and then compare with the sqlquery produced by Heidi and just remove/change

After that it took me about 10 minutes to Copy/create about 20 tables

Eric