Step 5 - Export the JET Database to the SQL Server

SQL Server

Note: This step is optional, and only required if using a SQL Server database. If you are not using a SQL Server database go to the next step.

Use the Author-it Administrator program to export the JET Library database to a SQL Server database.

To Export a JET Library to SQL Server:

1. From the main menu of the Author-it Administrator, choose Export. The Export Database To SQL Server screen opens.
2. Enter the name of the server and the database.
3. To use a Trusted NT Connection to the database, make sure the "Use Trusted Connection" checkbox is ticked, then go to Step 5.

   

4. If you're not using a Trusted NT Connection to the database, make sure the "Use Trusted Connection" checkbox is blank, then enter the correct Login ID and Password.
5. Choose OK to begin the process, and make a cup of coffee while Author-it exports the database. If it's a big database, you may even need to make several cups. Progress is shown as the JET database is exported to SQL.

   

6. A Confirmation message is shown when the database has been successfully exported. Choose OK, then close the Export to SQL window.

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