103 reputation
1
bio website
location
age
visits member for 1 year
seen Aug 22 '13 at 20:23

Bedroom Coder, old school 8-bit fan


Aug
22
comment Migrating from SQL Server to MySQL using MySQL Workbench tool
Great! Thanks for all your help.
Aug
22
comment Migrating from SQL Server to MySQL using MySQL Workbench tool
I have checked MSSQL server (Management Studio this time not that MySQL Workbench) and for those columns data are stored as VARCHAR(8000) so based on that I can create same for MySQL side. Is this correct?
Aug
22
awarded  Scholar
Aug
22
accepted Migrating from SQL Server to MySQL using MySQL Workbench tool
Aug
22
comment Migrating from SQL Server to MySQL using MySQL Workbench tool
OK, got this to work following all answers above.
Aug
22
comment Migrating from SQL Server to MySQL using MySQL Workbench tool
It looks like I need to create table manually in that case and set it as VARCHAR instead of NVARCHAR then I need to set same data type in data migration part.
Aug
22
comment Migrating from SQL Server to MySQL using MySQL Workbench tool
Through MySQL Workbench migration wizard - Create Schemata step.
Aug
22
comment Migrating from SQL Server to MySQL using MySQL Workbench tool
Well, let me try that :) Thanks!
Aug
22
comment Migrating from SQL Server to MySQL using MySQL Workbench tool
Source column has text data and is set as NVARCHAR(8000). Select statement is done by MySQL Workbench so I even don't need to touch queries (but I can save them for command line execution if needed)
Aug
22
asked Migrating from SQL Server to MySQL using MySQL Workbench tool