Feature request #19613

Add write support for MS SQL Server in a Processing model

Added by Magnus Nilsson over 1 year ago. Updated over 1 year ago.

Status:Open
Priority:Normal
Assignee:-
Category:Data Provider/MSSQL
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:27440

Description

Hi
I would like to see support for writing processing model output (including geometries) to SQL Server.

History

#1 Updated by Giovanni Manghi over 1 year ago

SQL Server as in "MS SQL Server"?

#2 Updated by Magnus Nilsson over 1 year ago

Yes! Sorry for not being clear. MS SQL Server is very common in large organizations and it would be a great feature if a processing model could write to it.

#3 Updated by Giovanni Manghi over 1 year ago

  • Subject changed from Add write support for SQL Server in a Processing model to Add write support for MS SQL Server in a Processing model

Magnus Nilsson wrote:

Yes! Sorry for not being clear. MS SQL Server is very common in large organizations and it would be a great feature if a processing model could write to it.

If one of those organizations needs it then is just a matter to support the work to implement this feature.

As a "workaround" you could write a Processing plugin with a tool based on ogr2ogr to import data in MS SQL Server, see for example:

https://github.com/qgis/QGIS/blob/master/python/plugins/processing/algs/gdal/ogr2ogrtopostgislist.py

#4 Updated by Nyall Dawson over 1 year ago

  • Category changed from Processing/Modeller to Data Provider/MSSQL

Also available in: Atom PDF