Community
Showing results for 
Search instead for 
Do you mean 
Reply

Upgrading from Act 2000 to 2011 - SQL advice needed

Accepted Solution Solved
New Member
Posts: 2
Country: USA
Accepted Solution

Upgrading from Act 2000 to 2011 - SQL advice needed

I'm in the process of doing an upgrade from Act 2000 (5.0) to Act 2011 Pro.

We have 5 users, and our data files are currently on an ancient NT 4.0 shared folder.

We also have an SBS 2003 server, and I plan to migrate the data off the NT

server and over to that.

 

I've read through the various FAQs, support docs and forum posts and

am unclear on a few things.

 

1) Do I need to install Act with SQL on the SBS server.  I'm always reluctant

to install unncessary stuff on the server, especially SQL Express, since the

SBS Server alread runs an instance of SQL 2000.  I definately don't

want to get into a situation where Act breaks any of my servers native

SQL functionality.

 

2) Do I need to install Act/SQL on each workstation, if I install Act/SQL on

the server.

 

3) If I install Act/SQL on the workstation, can I skip installing it on the server?

 

I guess I'm a bit unclear on where the SQL portion needs to reside in

a multiuser environment, how Act interacts with SQL., and what the disadvantages are of not

using SQL on the workstation machines.  If I can avoid installing anything on the server

that would be preferable.  Any advise would be appreciated.

 

Thanks

Mark

 

 

 


Accepted Solutions
Solution
Accepted by topic author mgriswold
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Upgrading from Act 2000 to 2011 - SQL advice needed

1. ACT! 2011 uses SQL 2008... I don't think it would care if you also have SQL 2000 for other apps.

2. You can do a custom install and not install SQL on the workstations ... unless you use internet Mail

3. The database server is where you MUST have it

You might also see:
http://blog.glcomputing.com.au/2010/01/tips-for-converting-act-60-or-earlier.html

View solution in original post


All Replies
Solution
Accepted by topic author mgriswold
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Upgrading from Act 2000 to 2011 - SQL advice needed

1. ACT! 2011 uses SQL 2008... I don't think it would care if you also have SQL 2000 for other apps.

2. You can do a custom install and not install SQL on the workstations ... unless you use internet Mail

3. The database server is where you MUST have it

You might also see:
http://blog.glcomputing.com.au/2010/01/tips-for-converting-act-60-or-earlier.html
New Member
Posts: 2
Country: USA

Re: Upgrading from Act 2000 to 2011 - SQL advice needed

Thanks for the info.

 

If I understand the install docs correctly, skipping the SQL install on the workstations

will not allow users to create databases or do any database admin since that

relies on SQL, correct?  We don't need the internet email since we will integrate with

Outlook.  Any other advantages/disadvantages to avoiding SQL on the workstation?

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Upgrading from Act 2000 to 2011 - SQL advice needed

SQL databases must be created on a local volume, so needs SQL installed.

Yes, those are the only two areas that you'd need SQL locally