Product Home Page | Developer Site | Version | |
The Database Publisher wizard is used to publish an Access database to MySQL. The wizard is installed on the Windows (client) machine as described in Installing Database Publisher, and walks you through each step of the publishing process. In general, you will take the following steps:
Select the Access file you want to publish.
Verify that table, index, and column names in the Access database are valid in MySQL, and fix any names that are invalid.
Provide an authorization key and other information needed to unlock the application for use.
Specify the destination (MySQL) database to which you want to publish the Access database.
Review conflicting (duplicate) tables in the Access and MySQL databases, if any, and take desired actions.
Publish the Access database to MySQL.
Before you begin, make sure you have the following information:
Name of the Microsoft Access file you want to publish.
Name and port number for the Web server to which the Sun ONE ASP Administration Console is installed (used to verify the authorization key). If a proxy server is in use, you must know the name and port number for the proxy server.
Authorization key (unlocking password) for Database Publisher.
Server name and port number for the destination (MySQL) database.
User ID and password for the MySQL server.
This section describes how to perform each step of the publishing process.
In this section:
Opening the Database Publisher Wizard
Verifying the Authorization Key
Specifying the Destination Database
See also:
Copyright © 2003 Sun Microsystems, Inc. All rights reserved.