Trying to make a couple databases which contain everything that needs to be mapped for a few projects. For best conformity it would be great to keep style embedded within the database to enable a simple save as but the only way I can think of it to .qml all the different styles. As there will be >20 layers all in, don't really want a different .qml for each layer, takes up space and less easy!

But the symbology export doesn't ever seem to keep the symbology.

Can it be done?

Can save as different file type but wouldn't know which one is best.


In the layer properties, choose Style > Save Style > in the database.

  • Thank you! I was trying to save the style in the layers which I had then made into a SQLite Database - this worked when using the layers which had been saved into the database. – Belinda Feb 15 '17 at 8:46
  • @Belinda it should automatically add the style when you add the layer from the Browser panel in QGIS - this is incredibly handy in PostGIS for our enterprise users... – DPSSpatial Feb 15 '17 at 14:32
  • Thanks for this. Is there a way to embed a style in a database using ArcGIS Pro? With the aim being to have styles embedded in a database from both QGIS and ArcGIS Pro so that it looks the same in both programs, – TeddyTedTed Nov 20 '18 at 12:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.