We currently have 8 locations around the world with Access database on a
local machine in each location. Some of these locations are in remote areas
where network or internet connectivity is not available all the time. We are
looking to discontinue the Access database and migrate to either MS SQL
Server or Oracle.
We want to have local databases in each location and when ever there is
connectivity we want to be able to update the main database in the US. What
are the advantages of using SQL Server for this purpose and how can this be
done?
ThanksSQL Server 2000 Replication Overview
http://www.microsoft.com/sql/evalua...replication.asp
AMB
"ADW" wrote:
> We currently have 8 locations around the world with Access database on a
> local machine in each location. Some of these locations are in remote area
s
> where network or internet connectivity is not available all the time. We a
re
> looking to discontinue the Access database and migrate to either MS SQL
> Server or Oracle.
> We want to have local databases in each location and when ever there is
> connectivity we want to be able to update the main database in the US. Wha
t
> are the advantages of using SQL Server for this purpose and how can this b
e
> done?
> Thanks
>|||SQL Server is easier to admin if you don't plan to hire a dedicated
experienced Oracle DBA.
Its software license is also cheaper, dual core CPUs count as 1 CPU license.
SQL 2005 is just around the corner in November, you can check the June
preview.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
http://www.microsoft.com/sql/2005/p...05features.mspx
No comments:
Post a Comment