New Database Contact Fields

[alexserenity]

I Currently have 1 main database that is going to be split to 3 different categories. I created a new database, the one problem I am having is the fields are not the same as my main database. Is there a way to copy all the fields (map) from my main database to my new database so that I don't have to individualy create new fields?

 

[GLComputing]

Create the new database by opening the old database and:
File | Save | Save Empty Copy
This will create a new database with the same field structure as the old one

However, splitting a database like that is usually a bad idea. It's usually better to just use groups

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[alexserenity]

The reason we are splitting the database is because we have employees in the office that handle either new prospects or customers. One other reason is to increase the speed. Why would this be a bad idea? Do you have any suggestions?

 

[GLComputing]

What version of ACT!?
How many prospects?
How many customers?
How many employees?

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[alexserenity]

ACT Premuim for Workgroups 2006 Version 8.0.2.82
Total Contacts = 29755
Customers = 7000
Old prospects = 11000
Employees =25

 

[GLComputing]

ACT! 8 and later shouldn't suffer much impact at that sized database... you would notice a significant speed improvement if you went to ACT! 10 as it uses the newer MS SQL 2005.

It's usually easier on the employees to work with one database and not have to switch back and forth.

I'd keep moving "Old Prospects" to an archive database - just in case you need them again.

Make sure you have plenty of RAM on your ACT! server.

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[alexserenity]

Durkins Contact List Plus is what makes the ACT run much slower. All of our machines in the office have at least 2GB of RAM

This is our server Specs:
Microsoft Windows Server 2003- Standard Edition
Intel Xeon CPU 2.8GHZ
4GB of RAM

 

[GLComputing]

With that kind or RAM, unless you're running a lot of other stuff on the server, splitting the database shouldn't make much difference.

As I said, upgrading to ACT! 10 WILL give a noticable speed increase.

You might also speak to Jim and see if he has any suggestions related to his product

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[alexserenity]

4- 1 GB Module for a Dell PowerEdge SC1420 Server 2R

 

[alexserenity]

This is a little more specific:

General
Storage Capacity 1 GB

Upgrade Type System specific
Memory
Type DRAM

Technology DDR II SDRAM

Form Factor DIMM 240-pin

Memory Speed 400 MHz ( PC2-3200 )

Data Integrity Check ECC

RAM Features Dual rank , buffered

Module Configuration 128 x 72

 

[GLComputing]

None of that really matters... 2GB RAM on workstations is fine. For 25 users, you might want more on the server, but it depends what else is running on the server.

Either way, ACT! 10 will be faster.

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au