[Qgis-user] Changing data source from Postgis to Geopackage

[Paolo Cavallini]

This seems a good candidate for an extra function of the browser.
Probably a simple Py script or a plugin should do, at least as a prototype.

Better add a ticket not to forget?

All the best.



Il 11/05/2018 03:17 PM, Andreas Neumann ha scritto:
>
> Hi,
>
> Ok - I am doing it in the text editor.
>
> I also had to change
>
> <provider encoding="System">postgres</provider>
>
> to
>
> <provider encoding="System">ogr</provider>
>
> After doing this change, it worked.
>
> Andreas
>
> On 2018-11-05 15:01, Alessandro Pasotti wrote:
>
>> On Mon, Nov 5, 2018 at 2:54 PM Andreas Neumann <a.neumann at carto.net
>> <mailto:a.neumann at carto.net>> wrote:
>>
>>     Hi,
>>
>>     I have a relatively complex QGIS project with data storage in
>>     QGIS and would like to change the data source of all layers to
>>     Geopackage.
>>
>>     I already have a Geopackage with the exact same data structure
>>     like in Postgis (automatic export from Postgis through ogr2ogr).
>>
>>     Now I wonder what the best approach is to change all data sources
>>     from Postgis to Geopackage?
>>
>>     Texteditor and search/replace or is there something more comfortable?
>>
>>  
>> Hi Andreas,
>>  
>> you could first check if it works correctly with one layer, from the
>> python console
>> vl.changeDataSource('/my/new/path|layername=mylayername',
>> 'layer_name', 'ogr')
>>  
>> then exit without saving the project, make a backup and try search
>> replace.
>>  
>>
>> -- 
>> Alessandro Pasotti
>> w3:   www.itopen.it <http://www.itopen.it>
>
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20181105/5be13f70/attachment.html>