I have a table that have the following table structure
CREATE TABLE [dbo].[ASAT]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [ASATID] AS ('ASAT'+right('00000000000000000000' +CONVERT([varchar](19),[ID],0),(20))) PERSISTED NOT NULL, [Created] [nvarchar](8) NOT NULL DEFAULT (CONVERT([varchar],dateadd(year, (0),getdate()),(112))) ) ON [PRIMARY]
When I used the MySQL Migration Wizard to convert the above Microsoft database table structure, I got errors that both datatype for my fields
Created was not supported (in MySQL).
What are the recommended ways to proceed such data type differences when performing a database migration from SQL Server to MySQL?