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

Part: VII Appendixes > Database Conversion

Database Conversion

The process known as upsizing is the conversion of an Access database into a SQL Server database. You can upsize your database by following the steps outlined next:

1.
Open the database you wish to upsize within Access and select Upsizing Wizard from the Database Utilities submenu of Tools, as shown in Figure D.1.

Figure D.1. Select the Upsizing Wizard option to begin converting your Access database to SQL Server.


2.
The Upsizing Wizard dialog box appears. Select the network location of your SQL Server installation as well as the name for the database, as shown in Figure D.2.

Figure D.2. Specify the name of the SQL Server installation and a name for the database.


3.
Add all the tables that you want to convert into the new format, as shown in Figure D.3.

Figure D.3. Add the tables to be converted.


4.
Specify all necessary table attributes including options for Indexes, Validation, and Table Relationships. It may be best to stick with the defaults as shown in Figure D.4.

Figure D.4. Specify all the conversion options.


5.
Selecting Finish will begin the conversion process, as shown in Figure D.5.

Figure D.5. Wait a few minutes while the conversion is in progress.


6.
Open your copy of SQL Server Enterprise Manager and view the newly converted database. The results should look similar to Figure D.6.

Figure D.6. Launch SQL Server Enterprise Manager and view the newly converted database.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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