Re: [Qgis-user] Mssql offline table with sync

2016-07-30 Thread 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

Re: [Qgis-user] Mssql offline table with sync

2016-07-30 Thread Bo Victor Thomsen
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

Re: [Qgis-user] Mssql offline table with sync

2016-07-29 Thread damien stephens
Hi Goyo.. Thanks for your response. I don't believe the offline editing plugin will copy my mssql table? Either way, the idea is not to edit the database offline, just being able to view the data offline is the goal, then when coming back to a connection, getting the latest copy of the database

Re: [Qgis-user] Mssql offline table with sync

2016-07-29 Thread Goyo
2016-07-29 2:17 GMT+02:00 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

[Qgis-user] Mssql offline table with sync

2016-07-28 Thread 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