Ian, Let me know if there are any answers.
I've been thinking of the same thing and I was going down the path of: Analyse your table to work out what fields and field types are needed. Create the table in SQL server with a sql command Execute the sp_sw_spatialize_column Open the table locally. Insert the data Save to server Execute the sp_sw_create_rtree Add an entry into MAPINFO_MAPCATALOG I may still go down this path as there is an inssue with easyloader wanting to make character fields chars instead of varchars And although it uploads integer fields into Oracle spatial as integer, when you open the table from MapInfo again, it wants to make the oracle integers floats in MapInfo. So you have to force the oracle data table to be a decimal 13,0 to retain its integer status Evidently these translations are controlled by the ODBC or Oracle Client so you can't alter them from MapInfo. The process above offers a bit more control. r ------------------------------------------- Robert Crossley Agtrix P/L Australia Far Southern Queensland Office: 9 Short Street PO Box 63 New Brighton 2483 P: 61 2 6680 1309 F: 61 2 6680 5214 E: [EMAIL PROTECTED] W: www.agtrix.com Brisbane Office: 109 Milsom St Cooparoo 4151 Queensland P: 61 7 3843 3363 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian Tidy Sent: 02 December 2005 07:56 To: MapInfo-L Cc: [EMAIL PROTECTED] Subject: [MI-L] EasyLoader Hi, Is it possible to run EasyLoader from a command line? Or is there a command line version of EasyLoader? I have around 20 Tables that I want to load into SpatialWare for SQL server. Ideally I want to batch these and run them at night. Any ideas?? Cheers Ian Ian Tidy GIS Administrator Works Asset Department Napier City Council Hastings St, Private Bag 6010, Napier, New Zealand Phone +64-6-835-7579 Ext. 8115 Fax +64-6-835-7574 mailto:[EMAIL PROTECTED] http://www.napier.govt.nz <http://www.napier.govt.nz/> ###################################################################### Attention: This e-mail message and accompanying data may contain information that is confidential and subject to legal privilege. Any information provided is given in good faith. However unless specifically stated to the contrary, Napier City Council accepts no liability for the content of this e-mail or for the consequences of any action taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this e-mail message in error, please notify us immediately and erase all copies of this message and attachments. Thank you. _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
