Geosynkronisering

Changelog

UML Model

Downloads

Documentation for alternative subscriber for non-windows

Deprecated version

Oppdatering til sqlite i Subsscriber f.o.m. v 1.2.3

I versjon 1.2.3 ble abonnenten sin subscriber database endret til SQLite fra SQL Server Compact.

Konvertering skjer på følgende måte:

Last ned sqlite-tools-win32-x86-3310100.zip fra SQLite Download Page https://sqlite.org/download.html: A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff.exe program, and the sqlite3_analyzer.exe program.

SQL Server Compact to SQLite: http://erikej.blogspot.com/2013/03/sql-server-compact-code-snippet-of-week.html In order to create a SQLite database for the script file created (c:\temp\nwlite.sql), you can use the sqlite3.exe command line utility like so: sqlite3 nwlite.db < nwlite.sql

Eksempel:

Kopier inn følgende på samme mappe (i dette eksempelet NyTest):

Program: ExportSqlCe40.exe sqldiff.exe sqlite3.exe sqlite3_analyzer.exe

SQL server compact database: geosyncDB.sdf

Lage scriptet test.sql: C:\testSQLCompact2SQlite\NyTest>ExportSqlCe40.exe "Data Source=C:\testSQLCompact2SQlite\nytest\geosyncDB.sdf" test.sql sqlite

Import inn i ny sqlite base geosyncDB.db: sqlite3 geosyncDB.db < test.sql

External tools

A nice tool for creating featureStores and sql from xsd

Handy tool for editing Sql Server Compact files (use the 4.0 version)

Development

Autogenerated classes

WSDL svcutil

Diff showing needed edits to autogenerated code from svcutil: https://github.com/kartverket/geosynkronisering/commit/6b39e295fa45dc15b80a0e5eac6c95864386b855

Building .NET Core Subscriber

Make sure you have .NET Core installed:

https://www.microsoft.com/net/core

Publish

See https://github.com/dotnet/docs/blob/master/docs/core/rid-catalog.md#using-rids for RID

Windows 10 64bit

git clone https://github.com/kartverket/geosynkronisering.git

cd geosynkronisering/Kartverket.Geosynkronisering.Subscriber/Test_Subscriber_NetCore

dotnet publish -c Release --self-contained -r win10-x64

Ubuntu

git clone https://github.com/kartverket/geosynkronisering.git

cd geosynkronisering/Kartverket.Geosynkronisering.Subscriber/Test_Subscriber_NetCore

dotnet publish -c Release --self-contained -r ubuntu-x64

Mac

git clone https://github.com/kartverket/geosynkronisering.git

cd geosynkronisering/Kartverket.Geosynkronisering.Subscriber/Test_Subscriber_NetCore

dotnet publish -c Release --self-contained -r osx-x64