Database Server Considerations

The Microsoft^® Visual Database Tools provide a consistent visual interface that allows you to design and query all databases in the same way. However, there are many differences in the features supported by individual databases and in how databases implement database management commands.

For the most part, when using the Database Designer or Query Designer, you do not need to be aware of specific differences between databases. However, in a few cases you might find it helpful to know about the underlying database. For example, when you are working with the Database Designer, it is helpful to understand what data types your database supports. Similarly, the Query Designer creates slightly different SQL commands depending on whether you are working with Microsoft^® SQL Server™, Oracle, or another database.

Note   These topics are not intended to explain SQL Server databases. Instead, they highlight features unique to SQL Server that are exposed through the Visual Database Tools. For more details about using SQL Server databases, consult your SQL Server database documentation.