search

uncheckederror / Darkhorse

A modern front-end for the Land Information System.
MIT License
1 stars 0 forks source link

Translate the PL-SQL in the Data Models library into T-SQL #4

Open uncheckederror opened 4 years ago

uncheckederror commented 4 years ago

We need to translate the existing SQL statements executed by the data models in the DataAccess library into statements that can be executed by both the existing Oracle 11g SQL server and by the current version of MS-SQL which is the database we intend to migrate this back-end to.

We should all find or write some documentation on how to translate PL-SQL statements into more generic SQL statements.

erik-kitsap commented 4 years ago

Most of the existing Oracle SQL statements have been translated to MSSQL. Two are still outstanding: MobileHome and Building.

uncheckederror commented 4 years ago

@erik-kitsap Do you want me to handle these two Data Models? IIRC Mobile Homes is incomplete, I quit working on it just before the demo 2 weeks ago. Buildings should be complete though.