• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 29. Upsizing a Desktop Applicati... > Using the Upsizing Wizard

Using the Upsizing Wizard

After you have prepared your desktop database for upsizing, you’re ready to run the Upsizing Wizard. Let’s take a look at upsizing the Contacts2Upsize.mdb sample database. The upsize process does not permanently alter the original database, but the wizard does create temporary objects in this database as it upsizes it. It creates a new project file that contains the converted forms, reports, macros, and modules; converts the tables and queries to an SQL Server database; and connects the new project to that database.

Ensuring That Your Server Is Started

Before you begin, you must be sure you can connect to an SQL Server database system that lets you create a new database and tables, views, and stored procedures in that database. If you installed the Microsoft SQL Server Desktop Engine (MSDE) on your desktop machine, you should make sure the server service is running. (See the Appendix for instructions to install MSDE.) With MSDE, you can double-click the SQL Server Service Manager icon in the notification area of your Windows taskbar (the group of icons at the right end of the taskbar) to open the manager, shown in Figure 29-2. (If you can’t find the Service Manager on your taskbar, you can start it by clicking the Service Manager icon in the Startup group on your Start menu.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint