What external database should I use?

KB Home   |   What external database should I use?

Main.WhatExternalDatabaseShouldIUse History

Hide minor edits - Show changes to output

July 29, 2019, at 12:15 PM by Chris King - Keyword
Changed line 32 from:
[-Keywords: SQL Server, `PostgreSQL, MySQL, Oracle, Schema, RDBMS, Apache, Derby, Deployment -]
to:
[-Keywords: SQL Server, `PostgreSQL, MySQL, Oracle, Schema, RDBMS, Apache, Derby, Deployment, External Database -]
July 29, 2019, at 12:13 PM by Chris King - Tidied it up and clarified some points
Changed lines 3-6 from:
The internal PaperCut database is stable, scalable, self-maintaining and provides very good performance. For this reason most organizations do not need to run PaperCut on an external database system. However there are some good reasons to run PaperCut on an external database, and deciding which database can be a difficult task.

PaperCut has a number of [[https://www
.papercut.com/products/ng/manual/ch-ext-db.html|supported external databases]] that can be used with your PaperCut installation. One of our more popular questions we get asked when deciding to use an external database is '''''which one?'''''
to:
The internal Derby database that comes as standard with PaperCut is stable, scalable, self-maintaining and provides efficient performance. For this reason most organizations do not need to run PaperCut on an external database system. That being said, there are some good reasons to run PaperCut on an external database, and deciding which database can be a difficult task.

PaperCut has a number of [[https://www
.papercut.com/products/ng/manual/ch-ext-db.html|supported external databases]] that can be used with your PaperCut installation. One of the more common questions we get asked by customers is '''''which one?'''''
Changed lines 9-12 from:
PaperCut does not have a preference of external databases that should be utilized, and a large factor in deciding what external database you should use depends on your current knowledge of database administration. If you are already familiar with a family of database backends such as Microsoft SQL Server, `PostgreSQL, or Oracle, then it would be best for you to use these for your new external database.

Other minor factors to consider here are,
to:
PaperCut does not have a preferred external database that should be utilized, and a large factor in deciding what external database you should use depends on your current knowledge of database administration. If you are already familiar with a family of database systems such as Microsoft SQL Server, `PostgreSQL, or Oracle, then it would be best for you to use one that you're familiar with.

Other considerations might be;
Changed lines 14-15 from:
*Will you know how to run your own internal custom reporting using our [[https://www.papercut.com/kb/Main/DatabaseSchema|database schema]]?
to:
*Will you know how to run your own custom reporting using our [[https://www.papercut.com/kb/Main/DatabaseSchema|database schema]]?
Changed lines 24-27 from:
After these considerations, it's time to deploy your [[https://www.papercut.com/products/ng/manual/ch-ext-db.html|external database]].
to:

!!!I've made my
considerations, and am ready for the next step....

In that case, it's time to deploy your new external
database in PaperCut! Just follow the guide  [[https://www.papercut.com/products/ng/manual/ch-ext-db.html|HERE]]
May 02, 2013, at 03:46 AM by Josh - Added `
Changed line 29 from:
[-Keywords: SQL Server, PostgreSQL, MySQL, Oracle, Schema, RDBMS, Apache, Derby, Deployment -]
to:
[-Keywords: SQL Server, `PostgreSQL, MySQL, Oracle, Schema, RDBMS, Apache, Derby, Deployment -]
Deleted lines 25-26:
TODO link your page here: https://www.papercut.com/kb/Main/Miscellaneous
Changed line 27 from:
''Categories:'' [[Category.TODOFirstCategory|+]], [[Category.TODOSecondCategoryIfNeeded|+]]
to:
''Categories:'' [[Category.Databases|+]], [[Category.Architecture|+]]
Changed line 29 from:
[-Keywords: TODO keywords here if needed-]
to:
[-Keywords: SQL Server, PostgreSQL, MySQL, Oracle, Schema, RDBMS, Apache, Derby, Deployment -]
Changed lines 3-4 from:
The internal PaperCut database is stable, scalable, self-maintaining and provides very good performance. For this reason most organizations do not need to run PaperCut on an external database system. However there are some good reasons to run PaperCut NG on an external database, and deciding which database can be a difficult task.
to:
The internal PaperCut database is stable, scalable, self-maintaining and provides very good performance. For this reason most organizations do not need to run PaperCut on an external database system. However there are some good reasons to run PaperCut on an external database, and deciding which database can be a difficult task.
Added lines 3-4:
The internal PaperCut database is stable, scalable, self-maintaining and provides very good performance. For this reason most organizations do not need to run PaperCut on an external database system. However there are some good reasons to run PaperCut NG on an external database, and deciding which database can be a difficult task.
Changed lines 9-10 from:
PaperCut does not have a preference of external databases that should be utilized, and a large factor in deciding what external database you should use depends on your current knowledge of database administration. If you are already familiar with a family of database backends such as `PostgreSQL or Oracle, then it would be best for you to use these for your new external database.
to:
PaperCut does not have a preference of external databases that should be utilized, and a large factor in deciding what external database you should use depends on your current knowledge of database administration. If you are already familiar with a family of database backends such as Microsoft SQL Server, `PostgreSQL, or Oracle, then it would be best for you to use these for your new external database.
Changed lines 3-4 from:
PaperCut has a number of [[https://www.papercut.com/products/ng/manual/ch-ext-db.html|supported external databases]] that can be used with your PaperCut installation. One of our more popular questions we get asked when deciding to use an external database is '''''which one?'''''.
to:
PaperCut has a number of [[https://www.papercut.com/products/ng/manual/ch-ext-db.html|supported external databases]] that can be used with your PaperCut installation. One of our more popular questions we get asked when deciding to use an external database is '''''which one?'''''
Changed lines 7-8 from:
PaperCut does not have a preference of external databases that should be utilized, and a large factor in deciding what external database you should use depends on your current knowledge of database administration. If you are already familiar with a family of database backends such as PostGres or Oracle, then it would be best for you to use these for your new external database.
to:
PaperCut does not have a preference of external databases that should be utilized, and a large factor in deciding what external database you should use depends on your current knowledge of database administration. If you are already familiar with a family of database backends such as `PostgreSQL or Oracle, then it would be best for you to use these for your new external database.
Changed lines 3-4 from:
PaperCut has a number of [[https://www.papercut.com/products/ng/manual/ch-ext-db.html|supported external databases]] that can be used with your PaperCut installation. One of our more popular questions we get asked when deciding to use an external database is '''''which one?'''''. This article will go through the factors to consider when deciding on an external database to use, and what these factors include.
to:
PaperCut has a number of [[https://www.papercut.com/products/ng/manual/ch-ext-db.html|supported external databases]] that can be used with your PaperCut installation. One of our more popular questions we get asked when deciding to use an external database is '''''which one?'''''.
Changed lines 15-27 from:
If you have an existing database infrastructure already in place, you should look at incorporating the PaperCut database into it. This means you're bundling maintenance, administration, backups, costs, previous knowledge, and a lot of other factors into a single database infrastructure. 

!!!Cost








!!Subheading

to:
If you have an existing database infrastructure already in place, you should look at incorporating the PaperCut database into it. This means you're bundling multiple factors, including:

*Previous
knowledge
*Administration
*Backups
*Costs

After these considerations, it's time to deploy your [[https://www
.papercut.com/products/ng/manual/ch-ext-db.html|external database]].
Changed lines 9-22 from:
Other minor factors to consider here are, do you know how to run your own internal custom reporting using our [[https://www.papercut.com/kb/Main/DatabaseSchema|database schema]]?


!!!Do you have an existing database server you can use?

!!!







to:
Other minor factors to consider here are,

*Are
you familiar with the maintenance of this database?
*Will you know how to run your own internal custom reporting using our
[[https://www.papercut.com/kb/Main/DatabaseSchema|database schema]]?

!!!Do you have an existing database infrastructure you can use?
If you have an existing database infrastructure already in place, you should look at incorporating the PaperCut database into it. This means you're bundling maintenance, administration, backups, costs, previous knowledge, and a lot of other factors into a single database infrastructure.

!!!Cost







Added lines 1-30:
(:title What external database should I use?:)

PaperCut has a number of [[https://www.papercut.com/products/ng/manual/ch-ext-db.html|supported external databases]] that can be used with your PaperCut installation. One of our more popular questions we get asked when deciding to use an external database is '''''which one?'''''. This article will go through the factors to consider when deciding on an external database to use, and what these factors include.

!!!What are you most comfortable using?

PaperCut does not have a preference of external databases that should be utilized, and a large factor in deciding what external database you should use depends on your current knowledge of database administration. If you are already familiar with a family of database backends such as PostGres or Oracle, then it would be best for you to use these for your new external database.

Other minor factors to consider here are, do you know how to run your own internal custom reporting using our [[https://www.papercut.com/kb/Main/DatabaseSchema|database schema]]?


!!!Do you have an existing database server you can use?

!!!








!!Subheading

TODO link your page here: https://www.papercut.com/kb/Main/Miscellaneous

----
''Categories:'' [[Category.TODOFirstCategory|+]], [[Category.TODOSecondCategoryIfNeeded|+]]
----
[-Keywords: TODO keywords here if needed-]

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.

Article last modified on July 29, 2019, at 12:15 PM
Printable View   |   Article History   |   Edit Article