|
|
| 04
- The Advantages of SQL Server |
There are many advantages to having a synchronized
copy of your Outlook Public Folder data in in Microsoft SQL Server
database.
- Relational Database
SQL Server was designed as a robust, scalable relational
database.
- IT Standard
In certain companies SQL Server has become a declared standard
for all database applications. And typically a CRM application
in this context would be considered a database application, and
so may IT shops simply would prefer to have their data in SQL.
Often this is simply because there is more familiarity/expertise
around SQL.
- Easier Data Manipulation
It is easier to do mass updates of your data using SQL Query Analyser
than it is with an Outlook database, which typically has to be
manipulated using Visual Basic for Applications and the Outlook
Object Model, which are not as familiar to the IT Professional
as SQL Query Analyser.
- Easier Reporting
It is easier to connect Report Writers and Business Intelligence
tools to a SQL database than to an Exchange Public Folder store.
|
|
|
