Andrew, I would recommend either building a MapBasic application or just using a Workspace to perform this task. You only need to know three MapBasic commands to perform this:
Open Table <path and name of table> Server Refresh <name of table> Close Table <name of table> This can very easy by put into a workspace. You can use the task manager to run the workspace once a night. All that is required is that you have MapInfo installed in the computer running the task - this could also be the server Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Tracey Sent: Tuesday, January 17, 2006 9:09 AM To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] SQL Server & MapInfo I have uploaded some MapInfo tables into SQL server using easy loader. The tables are then downloaded to each individual PC and refreshed using the MapInfo DBMS tools on a regular basis. I want to download some of the tables to a network storage place, and update them on a nightly basis. Does anyone know how I can automate the update procedure, preferably doing it direct from SQL server, so it can be done overnight without needing MapInfo running. I would appreciate any thoughts. Andrew Tracey Information Support Officer Corporate Information Corporate Development South Tyneside Council Westoe Road South Shields NE33 2RL Tel: 0191 4247561 E-Mail : [EMAIL PROTECTED] ************************************************************************************************ ************************************************************************************************ Please do not print this e-mail if you can help it - and help protect the environment. ************************************************************************************************ This Message may contain confidential information and is protected by copyright. If you receive it in error please notify us and delete it without making use of or copying it. The addressee and other employees within the Council may read and copy any e-mail reply to this message and other e-mails you send to us. Whilst we use virus checking procedures we accept no liability for viruses and recipients must rely on their own virus checking procedures. ************************************************************************************************ The Council's web site address is www.southtyneside.info _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
