Upsizing an Access Database and Reports Over time,

Immediate recoverability In case of system failure (such as an operating system crash or power outage), SQL Server has an automatic recovery mechanism that recovers a database to the last state of consistency in a matter of minutes, with no database administrator intervention. Critical applications can be up and running again right away. Server-based processing Microsoft designed SQL Server from the beginning as a client/server database, where data and indexes reside on a single server computer that is often accessed over the network by many client computers. SQL Server reduces network traffic by processing database queries on the server before sending results to the client. Thus, your client/server application can do processing where it s done best, on the server. Your application can also use user-defined functions, stored procedures, and triggers to centralize and share application logic, business rules and policies, complex queries, and data validation and referential integrity code on the server, rather than on the client. Upsizing your Access database The best way to upsize an Access database is by running the wizard in Access. Not only does running the wizard save you time, the process is done right the first time. After you upsize your database to a more powerful database platform, using Reporting Services will be that much easier to implement for the reports formerly implemented in your Access database. To begin the Upsizing Wizard, find it in the Tools menu within Access (see Figure 20-5) and follow its prompts. The initial screen of the Upsizing Wizard will give you a choice between using an existing database or creating a new database. I would suggest starting with creating a new database. 362 Part VI: Migrating from Other Reporting Tools

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost JSP Web Hosting services

Bookmark the permalink.

Comments are closed.