Saving a Copy of a Table to a DBMS Server - MapInfo_Pro - 2023

You cannot save point data to a server in such a way that X and Y values are stored in separate columns.

To save a copy of a table to a DBMS server:

1. Choose a source table by doing one of the following:
   • If you have only one table open, on the HOME tab, in the File group, click Save Copy As.
   • If you have several tables open, on the HOME tab, in the File group, click Save Copy As. In the Save Copy As dialog box, choose a table from the drop-down list and then click Save As.
2. In the Save Copy of Table As dialog box, from the Save as type list, choose a destination for the table by selecting an open DBMS connection. The Save Copy of Table As dialog box automatically goes into DBMS Connection Mode (DBMS specific controls are displayed).
3. In the File name field, type the name of the table.
4. Click Save.

   SQL Server Spatial users may see the Select SQL Server Spatial Type dialog box. This dialog box displays when saving a table that is in a Latitude and Longitude coordinate system and when that coordinate system has a valid EPSG code. If you see this dialog box, choose store the data as one of the following and then click OK.

   • SpatialWare

     Select to store data as a SQL Server SpatialWare table.

   • SQL Server Spatial

     Select to store data as a SQL Server Spatial table, and then select to save objects as:

     Geometry - The SQL Server data type that represents information in a uniform 2-dimensional plane.

     Geography - The SQL Server data type that uses Latitude and Longitude angles to identify points on the Earth. If the data is not valid for saving as Geography and you select Geography, then an error message displays and the table does not save.

5. In the Save As dialog box, specify a location for the .TAB file associated with the DBMS table.
6. Click Save to save the table to the specified location.