Step 5 - Export the JET Database to the SQL Server

SQL Server

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

Note: On average, your library will double in file size when you export it to SQL Server. You may need to allocate more file system space before exporting.

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 functions requires that the you have at least db_dbadmin privileges on the SQL Server database.