[Qgis-user] Mssql offline table with sync

[damien stephens]

Agreed that would work, but it is just moving the synchronisation problem
upstream so that it now sits between my local SQL server and the main one
that every one works from.

I am thinking of trying to put together a Python program that will grab all
of the SQL requirements, download the table and over write the existing
version, but the only way I can see of doing it will require another setup
file to go with the shape or spatiallite file to store the SQL request
definition. Also I suck at Python.
Cheers
Damien

On Sat, 30 Jul 2016 14:30 Bo Victor Thomsen <bo.victor.thomsen at gmail.com>
wrote:

> If your field computer is windows based, You could install install MS
> SQL Server on the field computer, use this as your data store for QGIS
> and use a MS SQL Server specific solution for replication
>
> Regards
>
> Bo Victor Thomsen
>
>
>
> Den 29/07/16 kl. 02:17 skrev damos:
> > Hi. was wondering if there is any currently available method to have a
> > similar functionality to the way that mapinfo works with MSSql tables.
> > in a nutshell you have the option of a linked table or a live table.
> > I would like the linked option, where once the connection is made a local
> > copy of the table is created. this local copy can then be refreshed with
> the
> > push of a button.
> > This is great for field work where you dont have a reliable internet
> > connection. I know that I can get a live connection, save the live table
> as
> > a layer definition file then save as a shape or spatiallite table, then
> copy
> > and paste the styles across or set the default qml file, then close and
> > reopen the LDF and resave but that is a lot of messing around.
> > any assistance gratefully accepted.
> >
> > thanks
> > Damien
> >
> >
> >
> > --
> > View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Mssql-offline-table-with-sync-tp5278634.html
> > Sent from the Quantum GIS - User mailing list archive at Nabble.com.
> > _______________________________________________
> > Qgis-user mailing list
> > Qgis-user at lists.osgeo.org
> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160731/2db367fd/attachment.html>