AppGini Community Forums

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

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

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.

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/

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.