I am trying to migrate my MySQL DB to MsSQL.However, as you can see in the picture SQL Server Management Assistant cant recognise MySQL table columns.
alternative link https://ibb.co/HXxKMBx
Asked
Active
Viewed 80 times
1
Thom A
- 88,727
- 11
- 45
- 75
abdulkerim saltuk buğra
- 101
- 2
- 2
-
What datatype is that column? – Sean Lange Jan 22 '19 at 19:27
-
int or small int or bigint none of them is recognised – abdulkerim saltuk buğra Jan 22 '19 at 19:51
-
https://learn.microsoft.com/fr-fr/sql/ssma/mysql/project-settings-type-mapping-mysqltosql?view=sql-server-2017. And blog can be help you : https://blogs.msdn.microsoft.com/ssma/2011/02/07/mysql-to-sql-server-migration-how-to-use-ssma/ – Sanpas Jan 22 '19 at 20:57
-
https://www.sqlshack.com/migrate-mysql-tables-sql-server-using-sql-server-migration-assistant-ssma-ssis/ – Sanpas Jan 22 '19 at 21:03