Performing The Upsizing
As any data migration procedure Microsoft Access database upsizing requires fundamental refactoring of the database structure and source code. Even though some aspects of this procedure seem to be automatized by the Upsizing Wizard, there are still many points requiring human intervention. Following changes have to be done on upsizing
- Complete change of data access interface from DAO to ADO.
- Substantial change of Microsoft JET SQL to Transact-SQL.
- Substantial adaptation of object (e.g. tables, columns etc.) names.
- Reconception of the source code to optimally employ the new functionality of ADO and Microsoft SQL Server of the "upsized" solution.
Read more about this topic: Upsizing (database)
Famous quotes containing the word performing:
“Bottom. What is Pyramus? A lover or a tyrant?
Quince. A lover that kills himself, most gallant, for love.
Bottom. That will ask some tears in the true performing of it. If I do it, let the audience look to their eyes.”
—William Shakespeare (1564–1616)