rnunley
Posts: 12
Joined: Thu Jun 26, 2008 3:14 am

Microsoft SQL Server

Thu Jun 26, 2008 3:16 am

Is GPSGateServer compatible with Microsoft SQL Server 2005?

Thanks

altf4
Posts: 1035
Joined: Mon Feb 04, 2008 8:05 pm
Location: Thailand
Contact: Website

RE: Microsoft SQL Server

Thu Jun 26, 2008 7:21 am

you can change the config to use a MsSQL Driver ... but i never see a Database Schema for Microsoft Servers.



--
Backups are for WIMPS!
http://0x8.in.th/where (website position GpsGate Powered)

User avatar
johan
GpsGate
Posts: 15161
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: Microsoft SQL Server

Thu Jun 26, 2008 10:48 am

GpsGate Server is prepared for MSSQL, but we have not decided if we will enable that feature or not. There is some things missing like installation etc.

Regards,
Johan

Franson Support

altf4
Posts: 1035
Joined: Mon Feb 04, 2008 8:05 pm
Location: Thailand
Contact: Website

RE: Microsoft SQL Server

Thu Jun 26, 2008 11:19 am

Johan, can you maybe publish a mssql schema ?
for me it would be good enough for testing.

i dont like mssql .. but its far more performant than mysql, and its a native application for windows.



--
Backups are for WIMPS!
http://0x8.in.th/where (website position GpsGate Powered)

rnunley
Posts: 12
Joined: Thu Jun 26, 2008 3:14 am

RE: Microsoft SQL Server

Thu Jun 26, 2008 8:55 pm

Is there a manual installation I can preform for MSSQL?

agni
Posts: 2
Joined: Mon Jun 09, 2008 10:57 pm

RE: Microsoft SQL Server

Sun Jun 29, 2008 10:49 am

Hello Johan,

I am interested MSSQL2005 schema too. I will purchase immediately GPSGate Server if I can install it on MS SQL.

agni
Posts: 2
Joined: Mon Jun 09, 2008 10:57 pm

RE: Microsoft SQL Server

Thu Jul 03, 2008 10:37 pm

As far as I know Microsoft has a free of charge SQL product too. MSSQL Express 2005.
Honestly I do not know why Franson perefers MySQL if your development platform is .net.
If so, you should port the GPSgate SRV application to the native environment. Could you share information when Franson plans to support MSSQL database server?

Thank you!

User avatar
johan
GpsGate
Posts: 15161
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: Microsoft SQL Server

Fri Jul 04, 2008 1:21 pm

Yes, I guess you have a point there. I cannot set a date for this feature yet, since we got the short term priority set for other things (which you soon will see). But we will seriously consider this. If anyone else has opinions about which database to support, please make a post here.

Regards,
Johan

Franson Support

altf4
Posts: 1035
Joined: Mon Feb 04, 2008 8:05 pm
Location: Thailand
Contact: Website

RE: Microsoft SQL Server

Fri Jul 04, 2008 2:19 pm

to follow up about the database issue in general ...

Postgres would be a good consideration .. as its GPL (just like Mysql community) but it does support Geo-functions
and is project based. (gpsgate would run with just 30% of the tables .. as you can make real relationships between dynamic datasets..

things like moving a user between applications (as example) would be done with one statement.
geofencing or other GIS Functions are alot more easy to handle and cause less load.

just like in Oracle .. (but guess oracle is out of question because of the licensing)

Microsoft SQL does not support GISFeatures .. but in matters of compatiblity and performance .. MSDE MSSQL may be the best choice as its free because of franson NMEA Services are a .net application.



--
Backups are for WIMPS!
http://0x8.in.th/where (website position GpsGate Powered)

User avatar
johan
GpsGate
Posts: 15161
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: Microsoft SQL Server

Wed Jul 23, 2008 8:40 pm

GpsGate Server 2.0 BETA4 supports MSSQL, more information here:
http://franson.com/forum/topic.asp?TOPIC_ID=7907

Regards,
Johan

Franson Support

Return to “GpsGate Server - How to setup and use”