CONVERTING EXISTING APPLICATIONS
After you decide to migrate an existing file-server application to client/server, you should review your data structure to ensure that you have a well-designed, properly normalized database design. Then you'll need to prepare any existing queries, forms, and reports for the migration.
Starting with a Well-Designed Database
When you're ready to convert your application to SQL Server, you should first step back and analyze your data model. Is it properly normalized? Do any changes need to be made before the migration?
Note
You should make changes to the Access database rather than assume that it's easy to make changes when the data structure exists in SQL Server. Changing SQL Server database structures can be very ...
Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
