Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support
Hello Guest,  Login   
        
DOWNLOAD FREE EDITION
    
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
Migrating from Derby to SQL Server 2008  XML
Forum Index » SysAid Installation & Beyond
 
Author Message
[Post New]02/06/2010 06:55:03
    Subject: Migrating from Derby to SQL Server 2008
[Up]
Phil Stratford
Super SysAider

SysAider from release 6 United Kingdom
Joined: 06/04/2009
Messages: 61
Offline
Hi there,

I'm just installing a new server running Windows Server 2008 R2 Standard and SQL Server 2008 Standard. Both are 64-bit editions. Before I complete my installation is there anything wrong with this configuration for running SysAid? Is there anything in particular I should do? And how do I go about migrating from a Derby database on a standard PC where it has been running for over a year to my new SQL Server?

Thanks!
[Post New]02/06/2010 11:31:18
    Subject: Re:Migrating from Derby to SQL Server 2008
[Up]
BRob
SysAider

SysAider from release 6.5 United States
Joined: 10/05/2010
Messages: 26
Offline
I can't help you in regards to migration from Derby to SQL ... but

I can let you know that I've done a clean install of version 6.5 and 7.0 on a Windows 2008 machine with SQL 2005 and 2008 and I did not have any problems. Just make sure TCP/IP is enabled for SQL and you have the right permissions setup. As I said I'm of no help in regards to Derby to SQL migration but I know what you want to move to works
[Post New]02/06/2010 12:59:08
    Subject: Re:Migrating from Derby to SQL Server 2008
[Up]
cannojr
SysAider


SysAider from release 5.1 United States Pathfinder
Joined: 17/05/2010
Messages: 22
Offline
We are running Sysaid 7.0.04 in a Windows 2008 R2 64bit virtual machine with a SQL 2008 backend residing on the same machine and it is working great. In regard to the migration - We had our migration done a week or so ago by the superb sysaid support team. Sysaid support requested the necessary information from us and migrated the database from derby to ms sql 2008 over the weekend. They did an excellent job and it went off without a hitch.
[Post New]03/06/2010 05:28:37
    Subject: Re:Migrating from Derby to SQL Server 2008
[Up]
Phil Stratford
Super SysAider

SysAider from release 6 United Kingdom
Joined: 06/04/2009
Messages: 61
Offline
Thanks for the info, it's good to know that my set up will work, in theory at least! I'll get in touch with SySaid Support when the time comes, I'm very impressed that they'll do the migration for me! I don't think I know another software product for which the support is so good.
[Post New]08/07/2010 04:13:51
    Subject: Re:Migrating from Derby to SQL Server 2008
[Up]
GullySchio
SysAider


SysAider from release 7 Italy
Joined: 08/06/2010
Messages: 19
Offline
Hello everyone,

I have a problem. I have SysAid with MySql 2008. But the action builder in the escalation rule don't work.
I was forced to migrate the database from MySql 2008 to Derby. Now all works but I want to use the MySql database.
Have you got any news about this issue?

Thank you very much
Forum Index » SysAid Installation & Beyond
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
   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)
   03:00 AM - 05: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
Privacy Policy © Terms Of Use