Product images are crucial for selling your products online. Managing these images can be done in several ways. Go to the setup card (Administration > Setup) and you will see that there are 3 different options for storing your Media.
Database, External and Azure Storage - File Share.
Database (Smaller Catalogs)
Database is the standard and most used option for smaller catalogs. This means that images will be stored in the Business Central SQL database (BLOBs). This is the default Media Storage Type and does not require any configuration. You can find this setting by going to Administration > Setup and scroll down to the Media section.
If you don't have a significant catalog we do not recommend to change this setting.
For example if you have 1.000 items with 2 images each, where the average image size is 250 Kilobytes.
Then the sum is:
1.000 x 2 x 250 Kilobytes = 500.000 Kilobytes = 500 Megabyte
This will be no problem for your Business Central database and won't cause any performance issues.
A standard Business Central SaaS SQL database is 80 Gigabytes by default.
When working with the Database option for images, you can simply drag and drop images on to the blue plus sign on the item card and they will automatically be uploaded. First into the Business Central SQL database, and as a next step they will be synchronized with Magento as well. You will notice that the Storage Type displayed in the Image Line will show ''Database''
Please note that you are able to drag and drop multiple images at a time.
Pro's of using database storage:
- Using this type of storage requires no additional configuration, and your images are automatically saved in the Business Central backup.
Con's of using database storage:
- When your catalog gets bigger or if you have a large amount of images per item, your database will grow, which may result in performance issues in the long term. However we have functionality to easily migrate to Azure Storage at a later point in time.