Are there any Benefits if I switch over to SQL vs Derby

Home

Forums

Feature Requests

Beta Issues

SysAid Resources

Documentation

Support

Hello Guest,

DOWNLOAD FREE EDITION

Recent Topics

Hottest Topics

Online Members

Member Listing

Advanced Search

Are there any Benefits if I switch over to SQL vs Derby

Forum Index » SysAid CSS Forum

Author

Message

27/01/2010 14:07:38

Subject: Are there any Benefits if I switch over to SQL vs Derby

jdog
SysAider

SysAider from release 5.6

Joined: 15/08/2009
Messages: 1
Offline

I would like any feed back from someone that know of any Pros and Cons to switching from Derby over to SQL?

27/01/2010 15:30:18

Subject: Re:Are there any Benefits if I switch over to SQL vs Derby

johnb
Elite SysAider

SysAider from release 6

Joined: 04/01/2009
Messages: 185
Offline

you can use sql reporting services to get some reports out on things like server performance, availability etc

This message was edited 1 time. Last update was at 27/01/2010 15:31:38

28/01/2010 12:46:21

Subject: Re:Are there any Benefits if I switch over to SQL vs Derby

David Lee
SysAid Customer Relations

Joined: 24/06/2009
Messages: 26
Offline

Though the embedded Derby database is a good simple (and Free) database, it is known to be limited in options and actions, however, it is the only database type that SysAid can automatically backup.
And since SysAid fully supports it, it saves you the need to have knowledge of databases.

SQL databases (MsSQL and MySQL) are simpler to run, have more options, actions are performed using a third party application, and usually have an easy third party interface, but are not supported by SysAid.

There are also some that say the Derby database is not as stable as the SQL databases.

Is this what you had in mind ?

28/01/2010 14:47:08

Subject: Re:Are there any Benefits if I switch over to SQL vs Derby

CarlH
Super SysAider

SysAider from release 4.5

Joined: 30/01/2009
Messages: 67
Offline

You will also see some performance increases. Depending on how large your database is, access should be faster. When we upgraded a couple years ago, we saw a tremendous increase in speed.

As was mentioned, it's also easier to back it up, and you have all the features of SQL Server.

Forum Index » SysAid CSS Forum

Go to:

Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software

   SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Skype account:ilient
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011

   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   02:00 AM - 04:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software