en.unionpedia.org

Upsizing (database), the Glossary

Index Upsizing (database)

Upsizing is the term coined by Microsoft to describe the process of upgrading Microsoft Access Database to a Microsoft SQL Server.[1]

Table of Contents

  1. 18 relations: Access Database Engine, ActiveX Data Objects, Back-end database, Code refactoring, Data migration, Frontend and backend, Jet Data Access Objects, Microsoft, Microsoft Access, Microsoft SQL Server, Open Database Connectivity, Relational database, Rich client, SQL, Thin client, Transact-SQL, View (SQL), Visual Basic for Applications.

  2. Microsoft database software

Access Database Engine

The Access Database Engine (also Office Access Connectivity Engine or ACE and formerly Microsoft Jet Database Engine, Microsoft JET Engine or simply Jet) is a database engine on which several Microsoft products have been built. Upsizing (database) and Access Database Engine are Microsoft database software.

See Upsizing (database) and Access Database Engine

ActiveX Data Objects

In computing, Microsoft's ActiveX Data Objects (ADO) comprises a set of Component Object Model (COM) objects for accessing data sources.

See Upsizing (database) and ActiveX Data Objects

Back-end database

A back-end database is a database that is accessed by users indirectly through an external application rather than by application programming stored within the database itself or by low level manipulation of the data (e.g. through SQL commands).

See Upsizing (database) and Back-end database

Code refactoring

In computer programming and software design, code refactoring is the process of restructuring existing source code—changing the factoring—without changing its external behavior.

See Upsizing (database) and Code refactoring

Data migration

Data migration is the process of selecting, preparing, extracting, and transforming data and permanently transferring it from one computer storage system to another.

See Upsizing (database) and Data migration

Frontend and backend

In software engineering, the terms frontend and backend (sometimes written as back end or back-end) refer to the separation of concerns between the presentation layer (frontend), and the data access layer (backend) of a piece of software, or the physical infrastructure or hardware.

See Upsizing (database) and Frontend and backend

Jet Data Access Objects

Jet Data Access Objects is a general programming interface for database access on Microsoft Windows systems, primarily for Jet and ACE databases.

See Upsizing (database) and Jet Data Access Objects

Microsoft

Microsoft Corporation is an American multinational corporation and technology company headquartered in Redmond, Washington.

See Upsizing (database) and Microsoft

Microsoft Access

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools. Upsizing (database) and Microsoft Access are Microsoft database software.

See Upsizing (database) and Microsoft Access

Microsoft SQL Server

Microsoft SQL Server (Structured Query Language) is a proprietary relational database management system developed by Microsoft. Upsizing (database) and Microsoft SQL Server are Microsoft database software.

See Upsizing (database) and Microsoft SQL Server

Open Database Connectivity

In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS).

See Upsizing (database) and Open Database Connectivity

Relational database

A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970.

See Upsizing (database) and Relational database

Rich client

In computer networking, a rich client (also called a heavy, fat or thick client) is a computer (a "client" in client–server network architecture) that typically provides rich functionality independent of the central server.

See Upsizing (database) and Rich client

SQL

Structured Query Language (SQL) (pronounced S-Q-L; historically "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS).

See Upsizing (database) and SQL

Thin client

In computer networking, a thin client, sometimes called slim client or lean client, is a simple (low-performance) computer that has been optimized for establishing a remote connection with a server-based computing environment.

See Upsizing (database) and Thin client

Transact-SQL

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases.

See Upsizing (database) and Transact-SQL

View (SQL)

In a database, a view is the result set of a stored query that presents a limited perspective of the database to a user.

See Upsizing (database) and View (SQL)

Visual Basic for Applications

Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6.0 built into most desktop Microsoft Office applications.

See Upsizing (database) and Visual Basic for Applications

See also

Microsoft database software

References

[1] https://en.wikipedia.org/wiki/Upsizing_(database)

Also known as Upsizing.