Utility for converting from MSSQL to MYSQL

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
kingtbala
Posts: 1
Joined: 2016-10-14 13:31

Utility for converting from MSSQL to MYSQL

Post by kingtbala » 2016-10-14 13:44

We were trying to import data base structure from our windows server MSSQL but we had problem in importing with various errors.

we have seen there is also utility built in to import in csv and mysql format, is it possible to add mssql also.

or

is there any other utility which can do this ?

appreciate help

Noha Eshra
Moderator
Posts: 82
Joined: 2013-11-11 19:21

Re: Utility for converting from MSSQL to MYSQL

Post by Noha Eshra » 2016-10-18 13:44

You can export your data from MSSQL as csv and then you can use this csv once to build the table structure and then to import the data after generating the application.

For more information please follow this screenscast
http://bigprof.com/appgini/screencasts/ ... pplication

DevGiu
AppGini Super Hero
AppGini Super Hero
Posts: 151
Joined: 2016-05-27 09:08

Re: Utility for converting from MSSQL to MYSQL

Post by DevGiu » 2016-10-18 14:37

Noha Eshra wrote:You can export your data from MSSQL as csv and then you can use this csv once to build the table structure and then to import the data after generating the application.

For more information please follow this screenscast
http://bigprof.com/appgini/screencasts/ ... pplication
The problem of this way is that, AFAIR, CSV creation of data structure, last time I tested it, create all fields as varchars, and don't detects length and so on. Maybe I'm wrong, I didn't need it yet, but my last test was this way.
/Giuseppe
Professional Outsourcing Services

grimblefritz
AppGini Super Hero
AppGini Super Hero
Posts: 336
Joined: 2015-12-23 16:52

Re: Utility for converting from MSSQL to MYSQL

Post by grimblefritz » 2016-10-19 00:19

Of course, google is your friend for such things. A quick query for "convert mssql to mysql" yields numerous options. Here are just a few.

http://www.thegeekstuff.com/2014/03/mssql-to-mysql/

http://www.dbload.com/

https://convertdb.com/mssql/mysql

https://sourceforge.net/projects/ms2my/

Noha Eshra
Moderator
Posts: 82
Joined: 2013-11-11 19:21

Re: Utility for converting from MSSQL to MYSQL

Post by Noha Eshra » 2016-10-19 12:06

DevGiu wrote:
The problem of this way is that, AFAIR, CSV creation of data structure, last time I tested it, create all fields as varchars, and don't detects length and so on. Maybe I'm wrong, I didn't need it yet, but my last test was this way.

The problem is that the CSV file does not contain information about field type or lengths. And Therefore you have to configure them manually in AppGini.

Post Reply