105 reputation
3
bio website
location
age
visits member for 1 year, 4 months
seen Sep 5 at 17:00

Bedroom Coder, old school 8-bit fan


Sep
24
awarded  Autobiographer
Sep
5
awarded  Supporter
Sep
5
comment MySQL 5.1.73 to 5.6.17 structure + data export
Thanks! Not sure if GoDady has access to a terminal to do mysqldump, but I will double check that.
Sep
5
accepted MySQL 5.1.73 to 5.6.17 structure + data export
Sep
5
asked MySQL 5.1.73 to 5.6.17 structure + data export
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