06-12-2012 11:13 AM
06-12-2012 11:37 AM
06-12-2012 12:04 PM
LOL. I would love to recommend this account upgrade to the latest version of ACT!
However, the reality of it is small businesses don't want to spend money unless they absolutely have to.
Are you saying that there is not a way to move the DB to Windows Server 2008/2011 without problems?
06-12-2012 12:15 PM
06-12-2012 12:17 PM
06-12-2012 12:58 PM
The opportunistic locking is a serious issue with the ACT! program. In many cases people would have to run database maintenance multiple times in one day, For worse damage the database would need to be sent in for repair. The worst damage caused by opportunistic locking was loss of the database. This is a problem experienced by any database program based on codebase. ACT! 2005 and later resolved the problem by moving to SQL.
06-12-2012 01:31 PM
OK, you guys are really scaring me now. The last thing I want to do is sell my client a shiny new server and then lose all of his data when trying to move the DB.
Can I get a definitive answer about the liklihood of problems with moving this version of ACT!?
This is the stuff that work nighmares are made of.
06-12-2012 01:53 PM
06-12-2012 01:59 PM
Moving the database files (all 26 or them) to the new server wouldn't be the problem. However ACT! 6 did file and email attachments using links fo if the link path changes or the file isn't there the attaachment would be lost. On the other hand opportunistic locking can be a real nightmare because the codebase structure is make up of separate files but these files must be treated as a single structure. Opportunistic locking doesn't do that. A separate issue is that you can use an incremental backup program with the ACT! 6 database. The later ACT! SQL database has all the data in a single file connected to the SQL server. It does have some separate files such as layouts and templates that are separate from the main data file but they aren't critical to the data itself.
06-13-2012 10:26 AM
You might consider replacing the existing "last legs" server with a new (refurb) 2003 Server and dedicate it to ACT!, and go with the 2008/2011 server for everything else. If you setup pathing, drive shares and mapping to match the existing server, you'd make your life a lot easier.