0

Is there a way to convert a database from SQL Server to SQLite with geometry data type?

I've tried to use this:

But it has an error because of geometry data type in my database.

I want to convert the sql server using c# mvc. Because i have a web app that have an export function to a software that need a sqlite db

gray
  • 73
  • 2
  • 16
  • 1
    Possible duplicate of [Convert MySQL to SQlite](https://stackoverflow.com/questions/3890518/convert-mysql-to-sqlite) – JustBaron Sep 06 '17 at 09:32
  • sqlite should be able to handle WKT, try converting the geometry data in sqlserver to a WKT varchar column and export using that column – g2server Sep 06 '17 at 09:41
  • i cant do that. because the software that use the sqlite db needs the geometry data. – gray Sep 06 '17 at 09:45

0 Answers0