08-09-2011 12:05 PM
I have a dept here that set up ACT 2011 Premium on a PC. They have 15 internal users and now want to allow external VPN'd users to access the DB. That raised a big big red flag with our security dept. I am now tasked with moving the app off the PC and onto a server. I want to put the DB on one of our many SQL Sever boxes.
Since i do not have experience with ACT can someone explain to me if we need to have an app server involved or do the clients just need to connect to a DB server? I am going to assume that it is a SQL Express version on the PC. Is there a documented process for migration of the DB from that PC to a SQL Standard or Enterprise Server?
08-09-2011 01:03 PM - edited 08-09-2011 01:04 PM
The ACT! program does need to be installed locally on the same machine, so you will need ACT on the server. As for the version/type of SQL, you can go ahead and use SQL Express, or you can use your SQL Server and "attach" ACT to a new instance on that server.
Here are a couple KB articles that might get you started:
Finally, as far as "migration", what you will basically do it install ACT on the server, and move the database over, either via a Backup/Restore, or move the entire database folder:
Hope this helps...