2007 vs 2009

[p15650]

Sorry, posted this in another threat incorrectly...

Hi,
Looking to upgrade to 2009 from 2007.

During install, most computers did ok except for sever [xp pro] where the sql install gave an error in the last few seconds of the install [based on what i saw with the other computers that worked] with the error saying something about an instance of the user existed!!! All theses computers had act 2007 installed previouslty.

Noticed that sql manager only shows act7 as database on server.

1. does act 2009 use the same database server as 2007 and therefore shows Server/ACT7 on sql server service manager screen [same as 2007 name]?

2. eventghough the install of sql failed, act installed ok and all database functions on the server work fine with a database i created. If everything is working, do i need to worry about problems happening later?

3. Is there anyway to install the server on microsoft server 2000?

4. i noticed 2009 now allows you to do automated backups and relationships. Do you think 2009 is much superior to 2007?

thank you for your help

 

[GLComputing]

1. ACT7 has been the SQL instance name since ACT! 2005 (7.0)

2. Should be ok

3. Windows or SQL Server?
Windows Server 2000 not supported by ACT! or MS for some time
SQL Server 2000 was used in ACT! 2005/2006, but not later

4. Yes. Better and faster in every way

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

http://blog.glcomputing.com.au

Join the LinkedIN ACT! Fanatics Group

http://www.linkedin.com/e/gis/49896