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
Utility for converting from MSSQL to MYSQL
-
- Moderator
- Posts: 82
- Joined: 2013-11-11 19:21
Re: Utility for converting from MSSQL to MYSQL
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
For more information please follow this screenscast
http://bigprof.com/appgini/screencasts/ ... pplication
Re: Utility for converting from MSSQL to MYSQL
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.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
/Giuseppe
Professional Outsourcing Services
Professional Outsourcing Services
-
- AppGini Super Hero
- Posts: 336
- Joined: 2015-12-23 16:52
Re: Utility for converting from MSSQL to MYSQL
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/
http://www.thegeekstuff.com/2014/03/mssql-to-mysql/
http://www.dbload.com/
https://convertdb.com/mssql/mysql
https://sourceforge.net/projects/ms2my/
-
- Moderator
- Posts: 82
- Joined: 2013-11-11 19:21
Re: Utility for converting from MSSQL to MYSQL
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.