Understanding the database implementation of Author-it

Author-it uses a SQL Server database to house all of the source material that make up your deliverables. You can export that database content to XML and publish to Word or HTML and other outputs, but the source is stored in a database.

For locally-run databases (meaning that Author-it and the database are on the same computer), you can use a Jet database (also known as Jet, or MSDE, or SQL Express) to store your content. Updated to add: With a Jet database, your content cannot 2 GB and the upper limit for users is 5.

For server database installations, where the content is stored on a separate database server, you can use SQL Server 7.0, SQL Server 2000, or SQL Server 2005. You can use a pre-existing SQL Server database such as one that your company uses already by simply asking for a database to be created with certain permissions already set. That configuration is what we do at ASI.

You can also install and run your own SQL Server database using SQL Express which is relatively painless to set up and the installation instructions from both Author-it and Microsoft are detailed and thorough. The limitation for this configuration is that your Author-it library cannot exceed 4 GBMB.

Here are some helpful links for researching the database aspect of Author-it:

Installing Author-it

System Requirements for Author-it

4 Comments

  • July 22, 2008 - 2:04 am | Permalink

    SQL Express limit is 4GB… Slightly better than 4MB ;-)

    We will be using SQL Express for our implementation here, so if I find anything useful I’ll post it.

  • July 22, 2008 - 4:17 am | Permalink

    Just a note…SQL Express falls under SQL, not JET :-) JET libraries have an upper limit of 2GB or 5 users.

  • July 22, 2008 - 6:14 am | Permalink

    Thanks Gordon and Char! No wonder I wanted to write a post explaining how databases and Author-it work – it can get confusing. Although I think the MB/GB problem was a typo.

    Thanks for crowdsourcing this entry. I love the Internets. :) I corrected the entry.

  • July 22, 2008 - 6:19 am | Permalink

    Oh and one other question I never could answer with my research is this: what’s a good rule of thumb for the amount of content compared to MB of data? I know that graphics would take up more room, but is there a general rule you apply when sizing a new installation?

  • Leave a Reply