SQL vs. MySQL?

reefdiver

Joined: 2003-04-24
Posts: 36

Posted: Thu, 2005-01-06 19:54

Hi guys,

I have the current version of G2 running on a MySQL-server, however I would like to "upgrade" to MSSQL. I know you guys have other problems right now but maybe someone has already changed the files so it works there as well? I have not much DB-knowledge, so I would appreciate any hints/help/files...

Cheers! Mark

----

Gallery URL (optional):
Gallery version:
Webserver (with version):
Datatabase (with version):
PHP version (eg 4.2.1):
phpinfo URL (optional):
Graphics Toolkit(s):
Operating system:
Web browser/version:

fryfrog

Joined: 2002-10-30
Posts: 3236

Posted: Fri, 2005-01-07 00:27

You didn't provide any information about your server, so just to let you know... MSSQL does not run on linux. Did you check the list of supported data bases yet (I haven't)? I can tell you that you should make an RFE if you want to see this feature, but you should not expect it quick as a bunny because the devs are pretty busy working on other things.

Your best bet is to do it yourself or find someone that can

Also, I am sure you realize it... but MySQL and MSSQL are not the same product, so you don't really "upgrade" from one to the other. You could also try other DBs like PostgreSQL or Oracle.

bharat

Joined: 2002-05-21
Posts: 7994

Posted: Fri, 2005-01-07 00:44

We don't support MSSQL yet. But we probably could (I say "probably" because I'm not sure what restrictions MSSQL places on SQL ANSI '92 which is the spec that we more-or-less comply with). Mindless made a post that explains the code that has to be changed to use SQLite -- it would be a similar process to adapt the code for MSSQL.

reefdiver

Joined: 2003-04-24
Posts: 36

Posted: Wed, 2005-01-12 07:45

Hi fryfrog and bharat!

Thanx for your replies. I was on holiday, that's why my reply took a while. My OS is Win Server 2003, I use ISS 6 and the latest PHP-build and MySQL-version. If someone gets G2 working with MSSQL, I would appreciate the info & files since I don't know how to change the files and I don't want to have to run MySQL and MSSQL at the same time. For the meantime however, I am more than happy with G2 and MySQL. Judging by the amount of people reading this link, the topic is of interest ;-)

Great work, and thanx again @ all for the support and help.

Mark

reefdiver Joined: 2003-04-24 Posts: 36	Posted: Thu, 2005-01-06 19:54
	Hi guys, I have the current version of G2 running on a MySQL-server, however I would like to "upgrade" to MSSQL. I know you guys have other problems right now but maybe someone has already changed the files so it works there as well? I have not much DB-knowledge, so I would appreciate any hints/help/files... Cheers! Mark ---- Gallery URL (optional): Gallery version: Webserver (with version): Datatabase (with version): PHP version (eg 4.2.1): phpinfo URL (optional): Graphics Toolkit(s): Operating system: Web browser/version:
	XUser login Username: * Password: * Create new account Request new password
fryfrog Joined: 2002-10-30 Posts: 3236	Posted: Fri, 2005-01-07 00:27
	You didn't provide any information about your server, so just to let you know... MSSQL does not run on linux. Did you check the list of supported data bases yet (I haven't)? I can tell you that you should make an RFE if you want to see this feature, but you should not expect it quick as a bunny because the devs are pretty busy working on other things. Your best bet is to do it yourself or find someone that can Also, I am sure you realize it... but MySQL and MSSQL are not the same product, so you don't really "upgrade" from one to the other. You could also try other DBs like PostgreSQL or Oracle.

bharat Joined: 2002-05-21 Posts: 7994	Posted: Fri, 2005-01-07 00:44
	We don't support MSSQL yet. But we probably could (I say "probably" because I'm not sure what restrictions MSSQL places on SQL ANSI '92 which is the spec that we more-or-less comply with). Mindless made a post that explains the code that has to be changed to use SQLite -- it would be a similar process to adapt the code for MSSQL.

reefdiver Joined: 2003-04-24 Posts: 36	Posted: Wed, 2005-01-12 07:45
	Hi fryfrog and bharat! Thanx for your replies. I was on holiday, that's why my reply took a while. My OS is Win Server 2003, I use ISS 6 and the latest PHP-build and MySQL-version. If someone gets G2 working with MSSQL, I would appreciate the info & files since I don't know how to change the files and I don't want to have to run MySQL and MSSQL at the same time. For the meantime however, I am more than happy with G2 and MySQL. Judging by the amount of people reading this link, the topic is of interest ;-) Great work, and thanx again @ all for the support and help. Mark

XUser login