我已经想到了如何处理这个问题的一些场景,并会感谢SF提供的任何输入.

1)内部sql数据库的一切.

Advantages: total control over
security,fast internal access via
whatever application platform we want.

Disadvantages: potential to bog down
our internet connection during heavy
ordering periods.

2)用于日常操作的内部sql数据库.复制支持订购系统到在线数据库所需的内容.

Advantages: total control over
security for internal portion of the
database. fast internal access.
Separates customer processes from
employee processes.

Disadvantages: duplicated data,extra
interface required to migrate data
between sites

3)完全迁移到Web服务器.

Advantages: Single database supporting
both admin and customer processes.
Easier access for mobile employees.

Disadvantages: Full faith in host for
security/backups. Slower direct DB
access from our location (in case we
want to use a non-web interface).

有什么想法吗？