Working with Other Databases

Although Microsoft Access is a very popular database, it is by no means the only one you will encounter. Many companies, especially larger firms, rely on larger-scale database systems such as Oracle, SQL Server, and DB2. These products provide much more power and reliability than desktop databases such as Access, dBASE, and FoxPro. You should be aware of the differences you'll commonly encounter when you move data from one place to another, and between different database environments.

For example, the data type aspects can vary widely and you should never assume data types are consistent between such products as Microsoft Access, Microsoft SQL Server, DB2, and Oracle. For instance, when you convert databases in Access 2000 to SQL Server 2000, memo fields are converted into ntext or nvarchar fields, which are very different. Other common differences relate to date and time values, currency, and special fields such as Pictures, Hyperlinks, and BLOBs (binary large objects).

0 0

Post a comment