Feature request #19613
Add write support for MS SQL Server in a Processing model
| 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 5 years ago
SQL Server as in "MS SQL Server"?
#2
Updated by Magnus Nilsson over 5 years 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 5 years 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 5 years ago
- Category changed from Processing/Modeller to Data Provider/MSSQL