Display full version of the post: Update MsSql table with Oracle table in Map3D

Andreijj
26.04.2012, 11:42
Hi!In my MSSQL database i have a table, which contains point geometries and other attributes. The most important is "symbol_name", and two empty column: "x_size" and "y_size"). In my Oracle database i have a table with "symbol_name", "x_size", and "y_size" columns. I would like to update my MSSQL table with these "x_size" and "y_size". Table join is working fine, but i cant copy the values from the oracle to the mssql (maybe with the bulk copy)?Thank you for your help, and sorry for my poor English