Exporting a JET Library Database to SQL Server

Use the Author-it Administrator program to export a JET Library database to a SQL Server Library database. You must first create the SQL Server database and assign database permissions to users, then create a JET Library 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 appears.
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 the Export Now! button, and then 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.

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