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:
“When performing an autopsy, even the most inveterate spiritualist would have to question where the soul is.”
—Anton Pavlovich Chekhov (1860–1904)