Upsizing (database), the Glossary
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
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.
- 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
- Access Database Engine
- ActiveVFP
- Adminer
- AutoNumber
- Business Intelligence Development Studio
- DBEdit
- DBeaver
- Data Transformation Services
- Database Workbench
- Epictetus Database Client
- Erwin Data Modeler
- Extensible Storage Engine
- FoxPro
- HeidiSQL
- Hekaton (database)
- History of Microsoft SQL Server
- Microsoft Access
- Microsoft Analysis Services
- Microsoft Query
- Microsoft SQL Server
- ModelRight
- Navicat
- Oracle SQL Developer
- Professional Association for SQL Server
- Report Definition Language
- SQL CLR
- SQL Database Studio
- SQL Server Agent
- SQL Server Compact
- SQL Server Express
- SQL Server Integration Services
- SQL Server Management Objects
- SQL Server Management Studio
- SQL Server Notification Services
- SQL Server Reporting Services
- SQLBits
- SQuirreL SQL Client
- Toad (software)
- Toad Data Modeler
- Upsizing (database)
- Visual Expert
- Visual FoxPro
- XLeratorDB
References
[1] https://en.wikipedia.org/wiki/Upsizing_(database)
Also known as Upsizing.