Page 1 of 1

Build web application with SQL server

Posted: 2016-06-22 01:08
by Monato
We have our own SQL Server 2012, I would like to build my appgini with backend connected to my SQL server. Is this option doable?

Thank you,

Re: Build web application with SQL server

Posted: 2016-06-23 21:23
by a.gneady
You could try editing the generated db.php file to add mssql or odbc functions to it .. though we haven't thoroughly tested this so far.

Re: Build web application with SQL server

Posted: 2016-08-13 13:21
by Appgini_tester
I'm just looking into AppGini now, but was disappointed to hear that it only officially supports MySql. I'm using Sql Server, at the office.

I've used several other CASE tools for PHP, but almost all of them generate levels of abstraction that make it difficult for a person familiar with that tool, to see what's going on. AppGini's code seems to be more generic and obvious.

Will continue to check it out, anyway. Just noticed this site, which purports to help users add MsSql support:

https://github.com/bigprof/appgini-mssql

Re: Build web application with SQL server

Posted: 2016-08-14 21:39
by Appgini_tester
How come my response to this was removed? Did I say something offensive?

Re: Build web application with SQL server

Posted: 2016-08-16 16:14
by Noha Eshra
It wasn't removed, it was just not approved "yet", as the very first post requires approval before posting.

Welcome to the forum :)

Re: Build web application with SQL server

Posted: 2016-08-17 12:17
by Appgini_tester
Yep, I realized that after sending it, but couldn't remove the comment. Thanks, Noha.

Re: Build web application with SQL server

Posted: 2018-10-24 20:09
by toconnell
Ahmad,
WHere is the SQL support at now? This was 2016

Re: Build web application with SQL server

Posted: 2018-10-24 20:30
by toconnell
Which driver do you recommend Ahmad? Microsoft JDBC DRIVER 6.0 for SQL Server or ODBC?
Please advise any information you can provide at all is helpful.. anyone

Re: Build web application with SQL server

Posted: 2018-10-31 11:42
by a.gneady
I'd recommend ODBC ... Regarding SQL Server support, we investigated it for some time before and it turned out to be a non-easy task, as most SQL queries would have to be rewritten since SQL syntax is different from MySQL ... We plan to revisit this some time later .. perhaps in AppGini 6.0.

Re: Build web application with SQL server

Posted: 2018-11-14 19:37
by toconnell
When is 6.0 planned? This is kinda a requirement now per the boss. So I have to make it so now.
so all the queries for each file?

Is there a step by step hidden away somewhere so I have some instructions on the actions that need to happen in each file?

Thanks, T

Re: Build web application with SQL server

Posted: 2018-11-28 11:42
by a.gneady
AppGini 6.0 is perhaps 4-6 months away. You'd have unfortunately to check the SQL queries in each generated file and manually edit them. There might be a way to do it centrally inside the sql() function defined in incCommon.php and admin/incFunctions.php .. The sql() function is where most of the SQL queries are executed .. So, you might find a method of parsing the MySQL version of SQL queries and converting them to SQL Server compatible ones. I didn't research this in detail but it could save a lot of work if done directly inside sql() function instead of having to chase all SQL code in all PHP files.

Re: Build web application with SQL server

Posted: 2020-05-07 15:54
by toconnell
Ahmad,
Any luck with the updates to this supporting SQL instead of MySQL?
Boss requires only SQL with new security and I have about 8 apps I could build in a minute with this if it output to SQL databases instead of MYSql. I cannot use it and buy it until then. Please let me know when available outputting to SQL and I will purchase immediately.

Thank you! Bunches Ahmad for all the hard work you do on this awesome program. I truely love it and cannot wait to showcase it's abilities once it is avialable to allow use of the SQL databases we use.

Thank you, Tina

Re: Build web application with SQL server

Posted: 2020-05-09 19:36
by a.gneady
Thanks for your feedback Tina. We haven't made progress regarding SQL Server porting yet unfortunately. It's still high on our roadmap but not in the very near future :/