Hello everyone,
I have two software that accept geometry in two different format. Software A uses WGS84 and B uses GDA94. I need to translate geo data on the fly between two system (e.g. A SQL trigger exists that updates record in other system's database table when data is updated and vice versa).
I want to know how can I convert geo data from one format to other using *within SQL*. I cannot use FME Desktop and FME API since that would require solution to work outside SQL Server.
Any help is appreciated, thanks in advance.
Regards,
Bhargav