September 4, 2008 at 10:59 am
CONTEXT: Multiple clients over TCPIP network at DOS level (running shell scripts)
So, basically, I'm interested in using posting some info from various clients (over 300) into a SQL server table (via stored proc is my thought, or a simple SQL insert into a table).
How would you accomplish this from DOS? All that's available is a DOS shell, and a TCPIP stack, oh, and some network fileshares.
Thanks.
September 4, 2008 at 12:04 pm
What about gathering the client info in text files and afterward importing the data in SQL Server?
September 4, 2008 at 2:33 pm
If these client machines do have Windows installed on them but you're just scripting something to run in command line (DOS) mode, you can use the SQL Server Configuration Manager to set up aliases on the client machines to associate a name to that IP address, and use SQLCMD to run your SQL script.
September 4, 2008 at 5:38 pm
Yeah - I'd love to do that, but this is for live status of the nodes as they reboot and enter a (pure) dos mode for some work, then reboot back into windows.
So, while I can do a batch update once back into windows, the idea is for status updates while in DOS since the delay in DOS mode can be hours at a time.
Thanks for helping with this weird situation! 😎
September 5, 2008 at 6:40 am
Could you have the clients write the information to text files on a central file share?
A scheduled task/SQL Agent job regularly triggering an SSIS package or bcp job could then load the files into your database as they arrive.
September 5, 2008 at 8:19 am
That's not a bad idea. Hmm...maybe to a RAMDRIVE mapped as a network share...that would work since the multiple file IO wouldn't be a constraint.
What I'm looking for (ideally) would be a dos level tool that can piggyback onto TCP/IP and send:
usrname / password (encrypted as DOS level), and an insert or stored procedure to a SQL server (specific port is fine).
This tool is to be used on various types of networks (large portion is on an isolated network), while other pieces are from a corporate business network, while still others would be coming from VNC connections.
But I suppose the text files + SSIS package would work pretty well, except I'm concerned about the latency...but hopefully on a RAMDrive it would be low enough.
If I come up with something interesting, that's publicly available, I'll be sure to (generically) let you guys know.
Thanks.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply