Export a JET Library database to SQL Server

Library configuration & administration

Use the Author-it Administrator program to export a JET Library database to a SQL Server Library database. First create the SQL Server database and assign database permissions to users.

Before starting this step you will need a database on your SQL Server. You'll export your Author-it library to this database.

To export a JET Library to SQL Server:

  1. From the main menu of the Author-it Administrator, click Export. The Export Database to SQL Server screen appears.
  2. Type the name of the server and the database.
  3. To use a Trusted NT Connection to the database, make sure the "Use Trusted Connection" check box is selected, then go to Step 5.
  4. If you're not using a Trusted NT Connection to the database, make sure the "Use Trusted Connection" check box is cleared, then type the correct Login ID and Password.
  5. Click the Export Now! button. Large databases may take longer.

Note: This function requires that you have at least db_dbadmin privileges on the SQL Server database.