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

Chapter 16. Upsizing Wizard > The Upsizing Wizard

The Upsizing Wizard

To use the Upsizing Wizard, open the mdb database that you want to convert and then call the Wizard from the Tools menus by selecting Database Utilities, then Upsizing Wizard. In the first dialog box, select whether you want to create a new SQL Server database or use an existing database.

Creating a New Database

In the next step, select the SQL server to which the database is to be saved. If you are using MSDE, this will probably be your own computer. SQL Server and MSDE have their own security system, described in detail in Chapter 20, “Security.” This system regulates access to SQL Server/MSDE and the rights for users and user groups to the databases. If SQL Server or MSDE are installed on a Microsoft Windows NT or Microsoft Windows 2000 system, the Windows security information can be used. This is known as a trusted connection. In this case you do not need to fill in the Login ID and Password text boxes (see Figure 16-1).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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