Migrating from Access 2000 to SQL Server 2000 - Verifying functionality of existing objects
(Page 6 of 6 )
Now you will see that all the objects in the MS Access would function normally, as if nothing has happened. The next picture shows the DAP on the intranet after migrating the tables.
Updating Data
Updating the data is carried out at the SQL Server either via programming, or directly running queries, or stored procedures in the query analyzer. For example, in the above report for Customers, the city corresponding to the Company 'Alfreds Futterkiste' is 'Berlin'. By running the following query the city name 'Berlin' can be updated to 'Julich'.
UPDATE Customers
SET City = 'Julich'
WHERE (CustomerID = 'ALFKI')
This automatically updates the report since the linked table is updated as shown.
Summary
The tutorial describes migrating an MS Access database to SQL Server 2000. Although the export function of MS Access was used for exporting the data to SQL Server, the Data Transformation Services on the SQL Server can also be used for the transfer. The user defined objects on MS Access continue to function transparently, as if the data existed in the MS Access application. Since it is on the SQL Server it can be accessed over the network from multiple clients. Data security is now provided by the SQL Server.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 14 
